|
-
Hi,
The actual space occupied by table data is = blocks * db_block_size
Where blocks we get from dba_tables.
Also the Total size we get from the field, bytes from DBA_SEGMENTS, initial_extent and next_extent from DBA_TABLES
In the similar way how to find , how much space occupied by the index in a table..? There is no field blocks in DBA_INDEXES..?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote