CODEWITHSUNDEEP
oracle-databaseoracle11g
Amit Arora
Amit Arora

Reputation: 175

Oracle: Determine Partition Size

I have a table with 200 hash partitions, I like to monitor daily size growth (rows and size in MB) for each of the partition. For more information, another process loads / updates rows on this table on daily basis and I like to know the growth pattern.

I am not looking for overall table size script, but size of each partition.

Upvotes: 5

Views: 23662

Answers (1)

Emyl
Emyl

Reputation: 10536

You can check the size of your partitions with this statement:

SELECT partition_name, bytes/1024/1024 "MB"
FROM dba_segments
WHERE segment_name = 'MYTABLE'
AND segment_type = 'TABLE PARTITION';

Upvotes: 10

Related Questions