如何查看ORACLE的隐含参数

2022-05-06 09:59:14

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
--SUBSTR(A.KSPPINM, 1, 1) = ‘_‘ and
a.KSPPINM =‘_small_table_threshold‘
ORDER BY A.KSPPINM ;