V$PGA_TARGET_ADVICE View Is Empty (Doc ID 1375932.1)

Last updated on APRIL 06, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
Checked for relevance on Nov 11, 2011

Symptoms

After setting PGA_AGGREGATE_TARGET > approximately 12G the V$PGA_TARGET_ADVICE view is empty. 

SQL> alter system set pga_aggregate_target=4G scope=memory;

System altered.

SQL> select * from v$pga_target_advice;

PGA_TARGET_FOR_ESTIMATE PGA_TARGET_FACTOR ADV BYTES_PROCESSED ESTD_TIME
ESTD_EXTRA_BYTES_RW ESTD_PGA_CACHE_HIT_PERCENTAGE ESTD_OVERALLOC_COUNT
----------------------- ----------------- --- --------------- ----------
------------------- ----------------------------- --------------------
              536870912              .125 ON           106496         22
                  0                           100                    0
             1073741824               .25 ON           106496         22
                  0                           100                    0
...

14 rows selected.

SQL> alter system set pga_aggregate_target=12G scope=both;

System altered.

SQL> select * from v$pga_target_advice;

no rows selected

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms