![]() You can learn Top Schema of database and Schema size with following script. SELECT SEGMENT_NAME, round(SUM(BYTES)/power(2,20)) SEGMENT_SIZEįROM DBA_SEGMENTS where segment_type= 'TABLE' You can learn Top segment of database and Table size with following script. You want to learn which table is biggest in database or which schema is biggest in database. Select PARTITION_NAME,round(SUM(BYTES)/power(2,20)) SEGMENT_SIZE_MB from dba_segments where SEGMENT_NAME=upper('&TABLE_NAME') and PARTITION_NAME='PARTITION_NAME' group by PARTITION_NAME If your table is partitioned, you can find out the partition size as follows. select round(SUM(BYTES)/power(2,20)) SEGMENT_SIZE_MB from user_segments where owner='TABLE_OWNER' and segment_name= '' If you don’t have DBA rights, you can query it using user_segments view as follows. Where segment_type= 'TABLE' and owner='TABLE_OWNER' and segment_name= '' select segment_name,segment_type,round(SUM(BYTES)/power(2,20)) SEGMENT_SIZE_MB You can find out the Table size using the dba_segments views as follows. I will explain How to Find Table Size & Schema Size and Database Size in Oracle in this post.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |