| https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:266215435203 | ||||
| SELECT | ||||
| owner, table_name, TRUNC(sum(bytes)/1024/1024) Meg | ||||
| FROM | ||||
| (SELECT segment_name table_name, owner, bytes | ||||
| FROM dba_segments | ||||
| WHERE segment_type = 'TABLE' and owner = 'AP' ) | ||||
| group by table_name, owner | ||||
| order by 3 desc | ||||
| select TABLE_NAME, ROUND((AVG_ROW_LEN * NUM_ROWS / 1024), 2) ROW_SIZE_KB, (BLOCKS * 8) BLOCK_SIZE_KB | ||||
| from all_TABLES where owner = 'AP' | ||||
| order by TABLE_NAME | ||||
No comments:
Post a Comment