下面三个查询结果均可查询出随着内存参数设置的变化性能的变化情况，对oracle数据库内存的设置有一定的建议和指导作用。
select t.SGA_SIZE,t.ESTD_DB_TIME_FACTOR from v$sga_target_advice t order by sga_size
SELECT pga_target_for_estimate / 1024 / 1024 "PGA(MB)",pga_target_factor,estd_pga_cache_hit_percentage,estd_overalloc_count FROM v$pga_target_advice;
select a.MEMORY_SIZE,a.ESTD_DB_TIME_FACTOR from v$memory_target_advice a
select t.SGA_SIZE,t.ESTD_DB_TIME_FACTOR from v$sga_target_advice t order by sga_size
SELECT pga_target_for_estimate / 1024 / 1024 "PGA(MB)",pga_target_factor,estd_pga_cache_hit_percentage,estd_overalloc_count FROM v$pga_target_advice;
select a.MEMORY_SIZE,a.ESTD_DB_TIME_FACTOR from v$memory_target_advice a
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29135257/viewspace-2123340/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
