资源说明:oracle数据库监控脚本
select Username,
OSUSER,Consistent_Gets,Block_Gets,Physical_Reads,
100*( Consistent_Gets + Block_Gets - Physical_Reads)/
( Consistent_Gets + Block_Gets ) "Hit Ratio %"
from V$SESSION,V$SESS_IO
where V$SESSION.SID = V$SESS_IO.SID
and ( Consistent_Gets + Block_Gets )>0
and username is not null
order by Username,"Hit Ratio %";  
		
		
		
		
		
		
		
					
									本源码包内暂不包含可直接显示的源代码文件,请下载源码包。
							
		
 English
