Database Administration (MOSC)

MOSC Banner

Calculating pga_aggregate_target using v$pga_target_advice but values of ESTD_PGA_CACHE_HIT_PERCENTA

edited Nov 26, 2015 12:29PM in Database Administration (MOSC) 7 commentsAnswered ✓

Hi,

I am running the following query in a database 11.2.0.3.0

SELECT round(PGA_TARGET_FOR_ESTIMATE/1024/1024) target_mb,

      ESTD_PGA_CACHE_HIT_PERCENTAGE cache_hit_perc,

      ESTD_OVERALLOC_COUNT

FROM v$pga_target_advice;


TARGET_MB CACHE_HIT_PERC ESTD_OVERALLOC_COUNT

---------- -------------- --------------------

       320              0                   13

       640              0                    0

      1280              0                    0

      1920              0                    0

      2560              0                    0

      3072              0                    0

      3584              0                    0

      4096              0                    0

      4608              0                    0

      5120              0                    0

      7680              0                    0

     10240              0                    0

     15360              0                    0

     20480              0                    0


But values for ESTD_PGA_CACHE_HIT_PERCENTAGE and ESTD_OVERALLOC_COUNT are mainly 0:

Do you know the reason? ….. I know I have problems with PGA because “Undersized PGA” is one of the findings in ADDM Report but I cannot calculate the value based on v$pga_target_advice

Values for memory and statistics are setting like this:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center