SELECT a.ksppinm "Parameter", b.KSPPSTDF "Default Value", b.ksppstvl "Session Value", c.ksppstvl "Instance Value", decode(bitand(a.ksppiflg/256,1),1,'TRUE','FALSE') IS_SESSION_MODIFIABLE, decode(bitand(a.ksppiflg/65536,3),1,'IMMEDIATE',2,'DEFERRED',3,'IMMEDIATE','FALSE') IS_SYSTEM_MODIFIABLE 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 '/' -- AND a.ksppinm like '%lock%' /
Created
March 13, 2023 14:01
-
-
Save Tracnac/501f4b462ca549415833c3a437d78302 to your computer and use it in GitHub Desktop.
Oracle Hidden Parameter
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment