Initialization parameters value [message #489009] |
Wed, 12 January 2011 21:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
reym21
Messages: 241 Registered: February 2010 Location: Philippines
|
Senior Member |
![vyer.atarom@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
Good day!
I'm just wondering why my SQLPlus queries for db_cache_size & shared_pool_size resulted in values of 0 for both, while it had values of 106MB & 380MB respectively declared in init.ora?
How can I synchronized these values?
Thanks in advance.
|
|
|
|
|
|
|
|
|
|
Re: Initialization parameters value [message #489048 is a reply to message #489028] |
Thu, 13 January 2011 01:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Hi - you need to read up on the priority of parameter files. This is what you need to check: if both a static (or "init") file and a dynamic ("spfile") file exist, then which file will be used? Make sure you also work out how to instruct Oracle to use the init file, instead of the spfile fie.
As Michel says, the double under-score parameters are not manually entered parameters, but values generated by Oracle from memory, when someone issued the command CREATE PFILE FROM SPFILE; Read up on that, too.
And one more thing, do not try to edit the spfile! The reason will become clear when you read about it.
Cheers, John.
|
|
|