-
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
-
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!
-
can we create this dynamically without bouncing the instance ?...
-
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!
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|