global cache block transfer lost and corrupt statistics
SELECT
A.VALUE "GC BLOCKS LOST 1",
B.VALUE "GC BLOCKS CORRUPT 1",
C.VALUE "GC BLOCKS LOST 2",
D.VALUE "GC BLOCKS CORRUPT 2"
FROM GV$SYSSTAT A, GV$SYSSTAT B, GV$SYSSTAT C, GV$SYSSTAT D
WHERE A.INST_ID=1 AND A.NAME='gc blocks lost'
AND B.INST_ID=1 AND B.NAME='gc blocks corrupt'
AND C.INST_ID=2 AND C.NAME='gc blocks lost'
AND D.INST_ID=2 AND D.NAME='gc blocks corrupt';
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/46907/viewspace-541362/，如需转载，请注明出处，否则将追究法律责任。
上一篇：
查看表空间使用情况
请登录后发表评论
登录
全部评论
