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
-O
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 init.ora and
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 9: