Oracle Memory usage Recommended Performance view

The following three query results can be queried with the change in memory parameter settings changes in performance, the Oracle database memory settings have some suggestions and guidance role.


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

Oracle Memory usage Recommended Performance view