I know that I’ve posted before on a similar topic. This is slightly different. Say you want to find the SIZE of your F0911 and the size of it’s indexes (generally more than the data I might add). If you log in as the owner of the table (PRODDTA) for example, you can use this.
This will give the total in MB, mega bytes.
Data:
select sum(bytes)/1024/1024, 'f0911' from user_segments where segment_name = 'F0911' ;
Indexes:
select sum(bytes)/1024/1024, 'f0911index' From user_segments where segment_name like 'F0911\_%' ESCAPE '\' and segment_type = 'INDEX' ;
The only cool this is the use of ESCAPE to escape the _, which generally indicates ANY one character in oracle. This is how you can look for either % or _ as a literal in a string with a like statement.
No comments:
Post a Comment