Home » RDBMS Server » Server Administration » Initialization Parameters {Dynamic / Static List} (Oracle 10g)
icon6.gif  Initialization Parameters {Dynamic / Static List} [message #277188] Mon, 29 October 2007 03:27 Go to next message
priyamalhotra
Messages: 43
Registered: July 2006
Location: none
Member

Hi,

Can some one tell me the list of Intilization parameters which are dynamic and which are static.

A link may also be helpful.

Thanks,
Priya.

  • Attachment: 1.zip
    (Size: 387.11KB, Downloaded 125 times)

[Updated on: Mon, 29 October 2007 11:45]

Report message to a moderator

Re: Initialization Parameters {Dynamic / Static List} [message #277193 is a reply to message #277188] Mon, 29 October 2007 03:47 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

http://dbataj.blogspot.com/2007/01/about-parameter.html
Re: Initialization Parameters {Dynamic / Static List} [message #277195 is a reply to message #277188] Mon, 29 October 2007 03:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> desc v$parameter
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 NUM                                       NUMBER
 NAME                                      VARCHAR2(80)
 TYPE                                      NUMBER
 VALUE                                     VARCHAR2(512)
 DISPLAY_VALUE                             VARCHAR2(512)
 ISDEFAULT                                 VARCHAR2(9)
 ISSES_MODIFIABLE                          VARCHAR2(5 CHAR)
 ISSYS_MODIFIABLE                          VARCHAR2(9 CHAR)
 ISINSTANCE_MODIFIABLE                     VARCHAR2(5 CHAR)
 ISMODIFIED                                VARCHAR2(10 CHAR)
 ISADJUSTED                                VARCHAR2(5 CHAR)
 ISDEPRECATED                              VARCHAR2(5 CHAR)
 DESCRIPTION                               VARCHAR2(255)
 UPDATE_COMMENT                            VARCHAR2(255)
 HASH                                      NUMBER

Have a look at IS% columns.

Regards
Michel
Re: Initialization Parameters {Dynamic / Static List} [message #277196 is a reply to message #277188] Mon, 29 October 2007 03:52 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#i1013946
Previous Topic: Upgrading from Standard to Enterprise
Next Topic: patch info
Goto Forum:
  


Current Time: Fri Dec 09 11:53:16 CST 2016

Total time taken to generate the page: 0.05630 seconds