Home » RDBMS Server » Server Administration » init.ora
init.ora [message #63016] Thu, 02 September 2004 04:39 Go to next message
Jay
Messages: 127
Registered: October 1999
Senior Member
Dear All,

How to find the list of parameters that are actually active in the init.ora file /database.

Say for example, if I haven't set or commented the paramter "cursor_sharing" in the init.ora file then this parameter should not appear in the list which I require.

However, if I have set this parameter thru ALTER SYSTEM then it should appear.

Hope you will please let me know.

TIA

Jay.

 
Re: init.ora [message #63019 is a reply to message #63016] Thu, 02 September 2004 06:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please look into v$parameter.
ISDEFAULT 	Whether the parameter value is the default 
 
ISSES_MODIFIABLE  
 		TRUE - the parameter can be changed with ALTER SESSION 
		FALSE - the parameter cannot be changed with ALTER SESSION 
ISSYS_MODIFIABLE 
		IMMEDIATE - the parameter can be changed with ALTER SYSTEM 
		DEFERRED - the parameter cannot be changed until the next session 
		FALSE - the parameter cannot be changed with ALTER SYSTEM 
ISMODIFIED 
		Indicates how the parameter was modified. If an ALTER SESSION was 
		performed, the value will be MODIFIED. If an ALTER SYSTEM 
		(which will cause all the currently logged in sessions' values 
		to be modified) was performed, the value will be SYS_MODIFIED. 
ISADJUSTED 	Indicates that the rdbms adjusted the input value to a more 
		suitable value (for example, the parameter value should be prime,
		but the user input a non-prime number, so the RDBMS adjusted the 
		value to the next prime number) 

Re: init.ora [message #63039 is a reply to message #63016] Fri, 03 September 2004 15:34 Go to previous messageGo to next message
gulshan
Messages: 19
Registered: January 2004
Junior Member
U can check Alert.log file. at the time of startup oracle write all the non default parameter in alert.log file.

u can check v$parameter view also.

Regd.
gulshan
Re: init.ora [message #63047 is a reply to message #63016] Sun, 05 September 2004 23:51 Go to previous message
Pramod
Messages: 18
Registered: April 1999
Junior Member
hi , check the alert.log of ur database.
everytime the database is started the non default parameters are written in that file
Previous Topic: how can i see no.of instance running
Next Topic: system table space corrupt
Goto Forum:
  


Current Time: Fri Sep 27 08:25:42 CDT 2024