> SPACEMON Utility - ORCL, 12/07/2000 21:00 > > Spacefix Report, Version 2.1, February 7, 2000 > > Objects will be resized (e.g. NEXT_EXTENT) if they have extended over > the last three collection periods, or the object has extended five times > in a 12 month period and the NEXT_EXTENT size has remained the same. > > Objects but will be skipped if: > 1) NEXT_EXTENT > 16MB > 2) Object type is not TABLE, TABLE PARTITION, INDEX, INDEX PARTITION > 3) The last recorded NEXT_EXTENT size does not match the current actual > NEXT_EXTENT size > > The following storage changes are being made: > Processing objects that have extended for three consecutive collection periods with the same NEXT_EXTENT size: ALTER TABLE GL.GL_JE_LINES ( NEXT 16777216 ) Processing objects that have extended 5 times in 12 months with the same NEXT_EXTENT size: ALTER TABLE PO.PO_HISTORY_VENDORS STORAGE ( NEXT 1048576 ) ALTER INDEX PO.RCV_SHIPMENT_LINES_N1 STORAGE ( NEXT 524288 ) Skipping object, NEXT_EXTENT too large: AP.AP_AE_LINES_U1 ALTER TABLE AP.AP_AE_LINES_ALL STORAGE ( NEXT 524288 ) Skipping object, NEXT_EXTENT already changed in DB: AR.AR_STATEMENT_LINE_CLUSTERS ALTER INDEX AP.AP_TRIAL_BALANCE_N1 STORAGE ( NEXT 8388608 ) Skipping object, NEXT_EXTENT too large: GL.GL_BALANCES Skipping object, NEXT_EXTENT too large: GL.GL_BALANCES_N3