Solved

A Question about some of  Oracle hidden parameters

Posted on 2012-03-17
1
565 Views
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.
Pradeep.
0
Comment
Question by:uompradeep
1 Comment
 
LVL 5

Accepted Solution

by:
Bajwa earned 500 total points
ID: 37733146
http://apps.cocreate.com/downloads/EU-OSM/software/oracle/CPU-Jan-2010/10.2.0.4/win64/README.html


_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
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

914 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now