Home » RDBMS Server » Server Administration » Dynamic Initializiattion Parameters
Dynamic Initializiattion Parameters [message #133314] Thu, 18 August 2005 08:33 Go to next message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Hi All,

I think ths is a basic question, but I searched metalink for nothing.
I do need a list of the database parameter which are NOT online changeable since Oracle 9i.

TiA
Uwe
Re: Dynamic Initializiattion Parameters [message #133316 is a reply to message #133314] Thu, 18 August 2005 08:41 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Look at the v$parameter view. ISSESMODIFIABLE and ISSYSMODIFIABLE columns to tell you that.

Jim
Re: Dynamic Initializiattion Parameters [message #133318 is a reply to message #133314] Thu, 18 August 2005 08:49 Go to previous message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Thanks Jim,

this is one way.
I thought that there will be a list, but i will gather the rwsults this way.

regs
Uwe
Previous Topic: act as a different schema
Next Topic: DDL are very slow on Oracle9i
Goto Forum:
  


Current Time: Sun Jan 26 10:29:07 CST 2025