Message-Id: <10602.115658@fatcity.com> From: Ari D Kaplan Date: Mon, 28 Aug 2000 12:13:33 -0500 (CDT) Subject: Re: init.ora doubt > Hello, > Is it possible to edit/change init.ora and reflect the changes while the DB > is mounted? > TIA > Swapna > Swapna, Some parameters may be modified while the database is up. To determine which parameters these are, use the ISSYS_MODIFIABLE column in the V$PARAMETER data dictionary view: SELECT NAME, ISSYS_MODIFIABLE FROM V$PARAMETER WHERE ISSYS_MODIFIABLE != 'FALSE'; In my version, 8.1.6, there are 62 such parameters. If it is "IMMEDIATE" then the parameter may be changed immediately. If it is "DEFERRED" then the change takes place for any future NEW connections to the database. Everyone currently connected is not affected. Please note that your question asked if this can be done by changing the init.ora. The true answer is NO, as the init.ora is checked only when the DB is started. You will have to issue the "ALTER SYSTEM SET ..." command in addition to modifying the init.ora for this to take place while the DB is up. Best regards, -Ari Kaplan Independent Oracle DBA Consultant <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-> <-> For 380+ Oracle tips, visit: <-> <-> <-> <-> www.arikaplan.com <-> <-> <-> <-> email: akaplan@interaccess.com <-> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->