segment statistics


select segment_name,object_type,total_buff_busy_waits 
from ( select owner||'.'||object_name as segment_name,object_type,value as total_buff_busy_waits 
from v$segment_statistics 
where statistic_name in ('buffer busy waits') 
order by total_buff_busy_waits desc) 
where rownum <=10;

select segment_name,object_type,total_pyhsical_reads 
 from ( select owner||'.'||object_name as segment_name,object_type,value as total_pyhsical_reads 
 from v$segment_statistics 
 where statistic_name in ('physical reads') 
 order by total_pyhsical_reads desc) 
 where rownum <=10;

select segment_name,object_type,total_logical_reads 
from ( select owner||'.'||object_name as segment_name,object_type,value as total_logical_reads 
 from v$segment_statistics 
where statistic_name in ('logical reads') 
 order by total_logical_reads desc) 
 where rownum <=10; 

select segment_name,object_type,total_ITL_waits 
from ( select owner||'.'||object_name as segment_name,object_type,value as total_ITL_waits 
from v$segment_statistics 
 where statistic_name in ('ITL waits') 
order by total_ITL_waits desc) 
 where rownum <=10;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: