init.ora [message #63016] |
Thu, 02 September 2004 04:39 |
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 #63039 is a reply to message #63016] |
Fri, 03 September 2004 15:34 |
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 |
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
|
|
|