oracle数据库优化常用命令
2020-04-20 Admin老鹰 1433
--查看命中率的语句是 select physical_reads/(db_block_gets+consistent_gets) from v$buffer_pool_statistics; --监控事例的等待 select event,sum(decode(wait_Time,0,0,1)) "Prev", sum(decode(wait_Time,0,1,0)) "Curr",count(*) "Tot" from v$session_Wait group by event order by 4; --回滚段的争用情况 selec...
Read More

标签云

图文推荐

  • 网站首页
  • oracle故障处理
  • oracle优化
  • 恢复和备份
  • 百度收录
  • mysql问题
  • 镇店之宝

    • Copyright © 2012-2020 老鹰(北京)信息技术有限公司 All Rights Reserved.

    京ICP备 09008221号-3