Monday, 31 August 2020

Check Hidden parameters in Oracle Database

set line 200 pages 555
 col PARAMETER format a40
 col DESCRIPTION format a70
 col SESSION_VALUE format a10
 col INSTANCE_VALUE format a10

 SELECT a.ksppinm AS parameter,
        a.ksppdesc AS description,
        b.ksppstvl AS session_value,
        c.ksppstvl AS 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 a.ksppinm;

No comments:

Post a Comment