-
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
Last edited by adewri; 04-08-2003 at 11:52 AM.
Amar
"There is a difference between knowing the path and walking the path."
-
Amar,
I have the pga_aggregate_target parameter, but my question was to do with the advisory.
It's not there.
-
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
Amar
"There is a difference between knowing the path and walking the path."
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|