oraclestatspack实例

　　——计算数据缓冲区命中率

　　select value from v$sysstat where name='physical reads' 4383475

　　select * from v$sysstat where name='physical reads direct' 3834798

　　select * from v$sysstat where name='physical reads direct (lob)' 374616

　　select * from v$sysstat where name like 'consistent gets' 1198738167

　　select * from v$sysstat where name like 'db block gets' 53472785

　　x=physical reads direct+physical reads direct (lob)

　　100-(physical reads-x)/(consistent gets+db block gets-x)*100

　　100-(4383475-3834798-374616)/(1198738167+53472785-3834798-374616)*100

　　——共享池的命中率

　　select sum(pinhits)/sum(pins)*100 "hit radio" from v$librarycache;

　　——关于排序部分

　　select name,value from v$sysstat where name like '%sort%';

　　select sorts(disk)/(sorts (memory)+sorts(disk)) from dual

　　select 0/(17038425+0) from dual

　　——关于log_buffer

　　select name,value from v$sysstat

　　where name in('redo entries','redo buffer allocation retries');

　　redo buffer allocation retries/redo entries >1% 考虑增加log_buffer



　　——其他视图 　　

　　v$db_cache_advice、v$pga_target_advice、v$java_pool_advice 和 v$db_shared_pool_advice