Oracle
Oracle 히든파라미터 조회방법
WOOJIN24
2020. 6. 26. 14:33
sqlplus sys/sys as sysdba
col name for a34
col value for a15
col descrition for a30
col is_default for a15
col ses_modifiable for a15
col sys_modifiable for a15
select ksppinm name, ksppstvl value, ksppstdf is_default, decode(bitand(ksppiflg/256,1),1,'true','false') ses_modifiable, decode(bitand(ksppiflg/65536,3),1,'immediate',2,'deferred',3,'immediate','false') sys_modifiable, ksppdesc descrition from sys.x$ksppi i, sys.x$ksppcv v
where i.indx = v.indx and i.ksppinm like '%&1%';
또는
select ksppinm name,
ksppstvl value,
ksppstdf is_default
from sys.x$ksppi i, sys.x$ksppcv v
where i.indx = v.indx
and ksppinm like '%query_execution%';
SMALL