PGA_AGGREGATE_TARGET Advisory ?

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 ?

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

Code:

---

SQL> show parameter PGA

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

---

or

Code:

---

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

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

SQL>

---

HTH

Amar,

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

It's not there.

Quote:

---

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