PGA_AGGREGATE_TARGET Advisory ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: PGA_AGGREGATE_TARGET Advisory ?

  1. #1
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346

    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 ?

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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 12:52 PM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    Amar,

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

    It's not there.

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width