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

ORDER BY 1;

spool off

set markup html off

 

HTH – Antonio NAVARRO

Advertisements

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