Hi,
I was wondering how to check a table's current usage in terms of blocks/bytes against the allocated initial extent? I have set the next extent to be 0 to prevent auto-extent which will fragment the table. Tks.
Printable View
Hi,
I was wondering how to check a table's current usage in terms of blocks/bytes against the allocated initial extent? I have set the next extent to be 0 to prevent auto-extent which will fragment the table. Tks.
Have you tried using DBMS_SPACE utility?
;)
No, ok will check it out.Quote:
Originally posted by LKBrwn_DBA
Have you tried using DBMS_SPACE utility?
;)