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
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