OraFAQ Forum: Server Administration » Default parameter values

Home » RDBMS Server » Server Administration » Default parameter values

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

Default parameter values [message #127325]

Mon, 11 July 2005 05:04

vivekmenon_k
Messages: 9
Registered: March 2005
Location: India

Junior Member

If a parameter is not set, it takes a default value
Where is these default value taken from.

Report message to a moderator

Re: Default parameter values [message #127328 is a reply to message #127325]

Mon, 11 July 2005 05:11

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

It is hard coded and compiled into the Oracle binaries.

SQL> SELECT name, value, isdefault FROM v$parameter WHERE name = 'processes';

NAME                           VALUE                          ISDEFAULT
------------------------------ ------------------------------ ---------
processes                      150                            FALSE

Best regards.

Frank

Report message to a moderator

Previous Topic:	oracle not found error
Next Topic:	database create script from existing database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 07:45:47 CST 2025