SGA values are different in PFILE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: SGA values are different in PFILE

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    SGA values are different in PFILE

    Hello all..

    I changes the values of shared pool, large pool, and java pool size thru OEM. Then i Bounced the instance....now when i look at pfile init.ora file , it still shows Previous values...but when i do "show SGA", new values are shown.....

    How is that possible ?...I thought I picks up the values from pfile at the time of Instance Startup...So now where is it picking up these values ?.....

    Sun 5.8/Oracle 9.2

    thanks
    Ron

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    The values will come from the SPFILE in order to see the values in the PFILE you will need to issue the CREATE PFILE FROM SPFILE command.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Oct 2002
    Posts
    284
    can we create this dynamically without bouncing the instance ?...

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Yes you can.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #5
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    create pfile 'PFILENAME' from spfile 'SPFILENAME'

    can be done online

    HTH
    Gert

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