Discovering Hidden Parameters

One way to see the hidden parameters of the database, for instance and session is using the x$ views, of course, the use of these views is not very clear, since they are not documented.

The following example dumps the contents of the variables and generate a html file that you can open with a Web browser. Execute it from sqlplus and logged like sys user;


set markup html on spool on

spool db_info.html

set echo on

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 ‘/’


spool off

set markup html off




Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s