Home > Oracle, RDBMS > How to get full list of the Oracle hidden parameters?

How to get full list of the Oracle hidden parameters?

Oracle has many hidden parameters. You will not find them in V$PARAMETER or see them with SHOW PARAMETERS command as these are hidden. All these parameter start with “_” (underscore), like _B_TREE_BITMAP_PLANS.
These parameters are undocumented. You won’t find them in Oracle documentation. These parameters are for specific purpose only. Some of them are OS specific and used in unusual recovery situations. Some are also used to enable\disable new feature. You should be very much careful while using them. Please check with Oracle Support before changing them.

Here is a simple SQL query that you can use to find these parameters:

SELECT a.ksppinm "Parameter", a.ksppdesc "Description",
       b.ksppstvl "Session Value", c.ksppstvl "Instance Value"
FROM x$ksppi a, x$ksppcv b, x$ksppsv c
WHERE a.indx = b.indx
AND a.indx = c.indx
AND a.ksppinm LIKE '/_%' escape '/'
ORDER BY 1;
Advertisements
Categories: Oracle, RDBMS Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: