Home » RDBMS Server » Server Administration » How to we know parameters that are set when create database command? (9i)
How to we know parameters that are set when create database command? [message #345672] Thu, 04 September 2008 07:30 Go to next message
meaku16
Messages: 4
Registered: September 2008
Junior Member
Dear All,

How can we find default value or current value of database parameters that are given in creating database command?

I can find some of the parameters from v$controlfile_record_section but not all.

Any help would be appreciated.

Thanks
Purvi
Re: How to we know parameters that are set when create database command? [message #345678 is a reply to message #345672] Thu, 04 September 2008 07:42 Go to previous messageGo to next message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
hi, try v$parameters
Re: How to we know parameters that are set when create database command? [message #345680 is a reply to message #345678] Thu, 04 September 2008 07:49 Go to previous messageGo to next message
meaku16
Messages: 4
Registered: September 2008
Junior Member
can you pls show me example for showing parameter

maxlogmembers
maxinstances

THanks
Purvi
Re: How to we know parameters that are set when create database command? [message #345681 is a reply to message #345680] Thu, 04 September 2008 07:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
maxinstance is in database section
maxlogmembers is not in v$controlfile_record_section

Regards
Michel

[Updated on: Thu, 04 September 2008 07:57]

Report message to a moderator

Re: How to we know parameters that are set when create database command? [message #345682 is a reply to message #345680] Thu, 04 September 2008 07:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
alter database backup controlfile to trace

Might help, to some extent.
Re: How to we know parameters that are set when create database command? [message #345684 is a reply to message #345680] Thu, 04 September 2008 08:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14191/osbackup005.htm
Re: How to we know parameters that are set when create database command? [message #345686 is a reply to message #345682] Thu, 04 September 2008 08:03 Go to previous message
meaku16
Messages: 4
Registered: September 2008
Junior Member
Thanks All!!!!!

-Purvi
Previous Topic: Put SYSTEM TABLESPACE DICTIONARY MANAGED TO LOCALLY MANAGED
Next Topic: Schema lock
Goto Forum:
  


Current Time: Sun Dec 04 20:27:41 CST 2016

Total time taken to generate the page: 0.05231 seconds