PGA_AGGREGATE_TARGET Advisory ?

[Horace]

Hi All,

Reading Note 223730.1 suggests that in 9iR2 there is an advisory for PGA_AGGREGATE_TARGET, but I can't find it in the parameters list. I can find db_cache_advice, but nothing for PGA.

Am I missing the point ?

Additionally, anyone had much experience with switching to Auto PGA memory management with DSS systems ?

[adewri]

Its not there in the parameter list because you have never set it before. But that does not mean that its not there. When a parameter is not hardcoded in the init.ora file, oracle picks up the default value.

Just login as sys user and do

SQL> show parameter PGA

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
pga_aggregate_target                 big integer                       25165824
SQL>

or

SQL> select name,ISDEFAULT,value from v$parameter where name like 'pga%'

NAME                                     ISDEFAULT                   VALUE
---------------------------------------- --------------------------- --------------------
pga_aggregate_target                     FALSE                       25165824

SQL>

HTH

[Horace]

Amar,

I have the pga_aggregate_target parameter, but my question was to do with the advisory.

It's not there.

[adewri]

Originally posted by Horace
Amar,

I have the pga_aggregate_target parameter, but my question was to do with the advisory.

It's not there.

there is no such parameter like advisory for PGA.

But yes there is a view synonym called v$pga_target_advice

may be thats what you are looking for...

Want to go deep go here

http://asktom.oracle.com/pls/ask/f?p...8759826405304,

HTH