SYS@orcl> ed
Wrote file afiedt.buf
Wrote file afiedt.buf
1 select parameter,
2 sum(gets),
3 sum(getmisses),
4 100*sum(gets-getmisses)/sum(gets) pct_succ_gets,
5 sum(modifications) updates
6 from v$rowcache
7 where gets > 0
8* group by parameter
SYS@orcl> /
2 sum(gets),
3 sum(getmisses),
4 100*sum(gets-getmisses)/sum(gets) pct_succ_gets,
5 sum(modifications) updates
6 from v$rowcache
7 where gets > 0
8* group by parameter
SYS@orcl> /
PARAMETER SUM(GETS) SUM(GETMISSES) PCT_SUCC_GETS UPDATES
-------------------------------- ---------- -------------- ------------- ----------
sch_lj_oids 34 7 79.4117647 0
dc_tablespaces 78042 10 99.9871864 0
dc_awr_control 103 1 99.0291262 5
dc_object_grants 1259 93 92.6131851 0
dc_histogram_data 26455 1695 93.5928936 0
dc_rollback_segments 1073 21 98.0428705 21
dc_sequences 16 15 6.25 16
dc_segments 12448 1159 90.6892674 10
dc_objects 61633 2977 95.1697954 165
dc_histogram_defs 41623 5360 87.1225044 36
dc_users 107972 114 99.8944171 2
-------------------------------- ---------- -------------- ------------- ----------
sch_lj_oids 34 7 79.4117647 0
dc_tablespaces 78042 10 99.9871864 0
dc_awr_control 103 1 99.0291262 5
dc_object_grants 1259 93 92.6131851 0
dc_histogram_data 26455 1695 93.5928936 0
dc_rollback_segments 1073 21 98.0428705 21
dc_sequences 16 15 6.25 16
dc_segments 12448 1159 90.6892674 10
dc_objects 61633 2977 95.1697954 165
dc_histogram_defs 41623 5360 87.1225044 36
dc_users 107972 114 99.8944171 2
PARAMETER SUM(GETS) SUM(GETMISSES) PCT_SUCC_GETS UPDATES
-------------------------------- ---------- -------------- ------------- ----------
outstanding_alerts 58 11 81.0344828 5
dc_files 135 9 93.3333333 0
dc_global_oids 3672 103 97.1949891 0
dc_profiles 197 2 98.9847716 0
global database name 3147 1 99.9682237 0
-------------------------------- ---------- -------------- ------------- ----------
outstanding_alerts 58 11 81.0344828 5
dc_files 135 9 93.3333333 0
dc_global_oids 3672 103 97.1949891 0
dc_profiles 197 2 98.9847716 0
global database name 3147 1 99.9682237 0
16 rows selected.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22126868/viewspace-764613/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
确定引起最多等待的SQL语句
请登录后发表评论
登录
全部评论
