Monday, March 25, 2013

Get Table and Index Size from database

Get Size of objects like Table or Index

Below sql gives the size of object in Data base.
Segment name = OBJECT _NAME
Ex:

 select owner, segment_name, sum(bytes)/1024/1024 size_in_m from dba_segments
   where segment_name like 'XXXXXX_RULES_MAINT%' group by owner, segment_name

No comments:

Post a Comment