ITPub博客

首页 > Linux操作系统 > Linux操作系统 > global cache block transfer lost and corrupt statistics

global cache block transfer lost and corrupt statistics

原创 Linux操作系统 作者:nokilled 时间:2009-01-18 21:18:11 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-30

  • 博文量
    108
  • 访问量
    287195