A Question about some of  Oracle hidden parameters

Posted on 2012-03-17
Medium Priority
Last Modified: 2012-04-01
Dear Sir,

Can you please explain me the purpose and usage of following Oracle Parameters.

(1).  _first_spare_parameter
(2). _third_spare_parameter
(3). _fourth_spare_parameter

Thank You in advance.
Question by:Pradeep Siriwardana
1 Comment

Accepted Solution

Bajwa earned 1500 total points
ID: 37733146

_first_spare_parameter is used by bug 6904068 in this bundle patch.
This parameter is not a simple on/off switch and it can take any numeric value. This fix should really not be used/turned on by customers who don't need it

_third_spare_parameter is used by bug 7452373 in this bundle patch.
This can be set to 100 in init.ora if there is a regression in "log file sync" after applying the patch.

_fourth_spare_parameter is used by bug 6661393. DBA may like to set _fourth_spare_parameter in init.ora

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to recover a database from a user managed backup

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question