分享一些oracle监控经常涉及到的sql脚本,这些都是我项目中已经验证过的,有需要的同学可以参考下!
数据库实例
select inst_id,instance_number,instance_name,host_name,instance_role,version,to_char(startup_time,'yyyy-MM-dd HH24:mi:ss') as runtime,status,database_status
from gv$instance order by inst_id asc;
Library Cache命中率select round(sum(pinhits)/sum(pins)*100,2),inst_id from gv$librarycache group by inst_id;
Buffer Cache命中率