#查询隐藏参数
set linesize 160
col ksppinm format a40
col ksppstvl format a30
col ksppdesc format a190
SELECT ksppinm, ksppstvl, ksppdesc
FROM x$ksppi x, x$ksppcv y
WHERE x.indx = y.indx
   AND ksppinm like '%&value%';

or

select (select instance_name from v$instance where instance_number=userenv('instance')) instance_name,
       ksppinm name,
       ksppstvl value,
       ksppstdf ISDEFAULT,
       decode(bitand(ksppstvf,7), 1, 'MODIFIED', 4, 'SYSTEM_MOD', 'FALSE') Changed,
       decode(bitand(ksppiflg/65536,3), 1, 'IMMEDIATE', 2, 'DEFERRED', 3, 'IMMEDIATE', ' ') SYS_Modify ,
       decode(bitand(ksppiflg /256,1), 1, 'TRUE', 'FALSE') SESSION_Modify,
       ksppdesc DESCRIPTION
from sys.xm$ksppi x, sys.xm$ksppsv y
where x.indx = y.indx
   AND x.inst_id = y.inst_id
   and x.inst_id=userenv('INSTANCE')
   order by ksppinm;

ITPub博客

[Oracle Script] select db parameter

最新文章