1. 首页
  2. IT资讯

v$shared_pool_advice,v$db_cache_advice,v$pga_target_advice 建议器的使用

使用Quest 的SQL Momitor在Oracle Enterprise Manager中找到的advicer 的一些sql用法。便于平时的参数调整。

/* OracleOEM */ SELECT shared_pool_size_for_estimate, shared_pool_size_factor, estd_lc_time_saved, estd_lc_time_saved_factor FROM v$shared_pool_advice ORDER BY shared_pool_size_for_estimate

/* OracleOEM */ SELECT name, block_size, size_for_estimate, buffers_for_estimate, estd_physical_read_factor, estd_physical_reads FROM v$db_cache_advice WHERE block_size = 8192

Timestamp: 14:27:12.671/* OracleOEM */ SELECT round(pga_target_for_estimate/1024/1024) estim_target_mb, estd_pga_cache_hit_percentage, estd_overalloc_count, pga_target_factor FROM v$pga_target_advice ORDER BY 1

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-84968/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/194908.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code