Search

Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Saturday, 26 May 2012

Undocumented Parameter Information in Oracle

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 '/';
----OR the other query----
select par.indx+1 numb,par.ksppinm name,val.ksppstvl value,
             par.ksppity type, val.ksppstdf is_default,
            decode(bitand(par.ksppiflg/256,1), 1,'True', 'False' ) is_session_modifiable,
            decode(bitand(par.ksppiflg/65536,3), 1,'Immediate', 2,'Deferred' , 3,'Immediate', 'False' ) is_system_modifiable,
            decode(bitand(val.ksppstvf,7), 1,'Modified', 4,'System Modified', 'False' ) is_modified,
            decode(bitand(val.ksppstvf,2), 2,'True', 'False' ) is_adjusted, par.ksppdesc description
from x$ksppi par, x$ksppsv val
where par.indx = val.indx ;
How to find Undocumented Session Parameter information
select par.indx+1 numb, par.ksppinm name,val.ksppstvl value,
             par.ksppity type, val.ksppstdf is_default,
            decode(bitand(par.ksppiflg/256,1), 1,'True', 'False' ) is_session_modifiable,
            decode(bitand(par.ksppiflg/65536,3), 1,'Immediate', 2,'Deferred' , 3,'Immediate', 'False' ) is_system_modifiable,
            decode(bitand(val.ksppstvf,7), 1,'Modified', 4,'System Modified', 'False' ) is_modified,
            decode(bitand(val.ksppstvf,2), 2,'True', 'False' ) is_adjusted,par.ksppdesc description
from     x$ksppi par, x$ksppcv val
where   par.indx = val.indx;
Note: In general you will only use these undocumented parameters at the request of Oracle Support.  The use of them can be damaging to a database and their implementation can and will change from release to release.

Visit for more information:

0 comments:

Post a Comment