initSID.ora file parameter

Hi ,

We using ECC 6.0 with Oracle , we need to change the parameter db_cache_sie from 294 mb to 1 gb , So i edit the file and change the parameter . Then i restart the system . After restart the system i checked the parameter it will changed to 1gb . But today i just checked the parameter , it will show the old parameter 294 mb .

So kindly tell me what is happening and tell me the solution to change the parameter .




Hi ,

Oracle 10g always use spfile for the purpose of maintaining database parameters .So you want to make any changes then first you need to create pfile from spfile because you cannot make changes directly in spfile as its not recommended by oracle.

So first change pfile from spfile by givind command create pfile from spfile via sql prompt .Then modify the parameter in pfile & again give command create spfile from pfile & restart your databse to make the changes effective.

Or the best solution to change the database parameter is to change via sql prompt prompt eg::

alter system set <parameter>=<value> scope=spfile



0 View this answer in context

Helpful Answer