Home » RDBMS Server » Server Administration » Delete default Oracle Parameter
Delete default Oracle Parameter [message #272489] Fri, 05 October 2007 04:36 Go to next message
Messages: 1
Registered: October 2007
Location: India
Junior Member
Hello Oracle Gurus,

Can anyone tell me how an Oracle parameter can be deleted. For e.g there is a oracle parameter CPU_COUNT in our oracle database with the default value. It is niether in the pfile nor the spfile. This parameter has become obsolete as of Oracle 9i and should be deleted. How can it be deleted? Can anyone tell me the command please?

Atul Lotlikar.
Re: Delete default Oracle Parameter [message #272493 is a reply to message #272489] Fri, 05 October 2007 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not obsolete and exists in all versions.
You MUST NOT set it, let it to its default value.
Remove it for your configuration file if it is there.

Re: Delete default Oracle Parameter [message #272524 is a reply to message #272489] Fri, 05 October 2007 07:15 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
This does not make sense. How can you delete it if you never set it?
Why bother if it is obsolete?

[edit: ok, if it were obsolete; apparently it is not]

[Updated on: Fri, 05 October 2007 07:16]

Report message to a moderator

Previous Topic: patch info
Next Topic: Why do they know about the space of leaf block?
Goto Forum:

Current Time: Sat Aug 19 04:23:14 CDT 2017

Total time taken to generate the page: 0.05221 seconds