[Oracle Script] select db parameter

tolilong發表於2017-07-02
#查詢隱藏引數
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部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-2141488/,如需轉載,請註明出處,否則將追究法律責任。

相關文章