Change parameters in Oracle
Sooner or later every Oracle dba need to change some configuration parameter... First thing i do is to check if database is running with spfile or init file. If database is running with spfile when you execute (if your database is 10g or higher your database probably has spfile) SQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /u01/app/oracle/product/11.2.0 /orcl/dbs/spfileorcl.ora SQL> spfile entry will give you the path where spfile is located, like above, if not, value column will be null.. 1-Modify WITH INIT: show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string initORCL.ora file: db_name='ORCL'...