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/92530/viewspace-520745/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/92530/viewspace-520745/