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

tolywang發表於2007-10-23
使用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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章