how oracle take effect on the new oracle configuration ?


  When I installing MySQL, all configuration saved in a configuration file call my.cnf, but the problem is , whenever there are changes on that file and we need to restart the MySQL in order for change to take effect.

   How about Oracle ? need restart whenever there are changes ? how configuration store ?
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SujithData ArchitectCommented:
Some of the initialization parameters are modifiable while the database is up, some others need a restart, Have a read at -

Have a look at the parameters modifiable at session/system/instance etc level at this link

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mark GeerlingsDatabase AdministratorCommented:
Oracle uses a parameter file to store this information.  In older versions of Oracle this was a plain-text file (called a "pfile") that was stored in the dbs sub-directory of the Oracle_home.  Oracle12 can still use that, but in Oracle11 and 12, the default is an "spfile" that is either in this same location, or in ASM, if you use ASM for your database.  This "spfile" contains some binary characters, so it is not directly editable.  You use "alter system ..." commands with either the "scope=spfile" or "scope=both" options to have Oracle write the new value to the spfile.

And as Sujith indicated, some of these Oracle parameters can be changed dynamically while the database is open.  Others require a database shutdown and restart.

You can use a query like this in Oracle to see which parameters can be changed dynamically, and which ones require a restart:
(Those with "FALSE" in the last column require a database restart.)

select substr(name,1,30) "Parameter", substr(value,1,45) "Value", isdefault,
isses_modifiable "Session", issys_modifiable "System"
from v$parameter
order by name;
marrowyungSenior Technical architecture (Data)Author Commented:
tks all
SujithData ArchitectCommented:
You are welcome.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.