OraFAQ Forum: Server Administration » Initialization Parameters {Dynamic / Static List}

Home » RDBMS Server » Server Administration » Initialization Parameters {Dynamic / Static List} (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Initialization Parameters {Dynamic / Static List} [message #277188]

Mon, 29 October 2007 03:27

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 1041 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

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

http://dbataj.blogspot.com/2007/01/about-parameter.html

Report message to a moderator

Re: Initialization Parameters {Dynamic / Static List} [message #277195 is a reply to message #277188]

Mon, 29 October 2007 03:51

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Initialization Parameters {Dynamic / Static List} [message #277196 is a reply to message #277188]

Mon, 29 October 2007 03:52

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

Report message to a moderator

Previous Topic:	Upgrading from Standard to Enterprise
Next Topic:	patch info

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 16:07:52 CDT 2024