Wednesday, December 18, 2013

How to find an Index size


select segment_name,segment_type,bytes/1024/1024 MB
 from dba_segments
 where segment_type='INDEX' and segment_name='your_index_name';

No comments:

Post a Comment

How to Trouble shoot Logfile_sync wait event

   First  Identify and break down LGWR wait events. Query wait events for LGWR. In this instance LGWR sid is 3 (and usually it is). select s...