Hi all,
I have a stupid question for all of you.
To change our Oracle parameters can we modify our parameter table to avoid
downtime (restart DB).
Thank you
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy
INET: [EMAIL PROTECTED]
Fat City
Title: RE: Change parameter without restart db
Sinardy,
Look at v$parameter, at ISSYS_MODIFIABLE. If it is FALSE, you have to restart the db for the change to take effect.
Lisa Koivu
Gimme a PC and I'll Break It, Guaranteed and DBA
Ft. Lauderdale, FL, USA
-Original Message
You must check in V$PARAMETER if that parameter you want modified
it's possible. In that view you have two columns ISSES_MODIFIABLE and
ISSYS_MODIFIABLE, and they say toy you if you can modify that parameter
to session or system level. If both are false only it's possible
modifing
Also look in the table v$parameter.
There is a collumn called ISSES_MODIFYABLE. The name stands for Is Session
Modifiable. i.e. Can you change the parameter on the fly in the session.
If this is true, then a bounce is not required.
-Original Message-
Sent: Tuesday, August 28, 2001