Hidden Parameter 보기

 

  SQL> show parameter    --> http://docs.oracle.com/cd/B19306_01/server.102/b14237/toc.htm

  SQL> ed param.sql

       set linesize 300
       set pagesize 50

       col name format a50
       col value format a20
       col description format a50

       select ksppinm name, ksppstvl value,
              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 description
       from sys.x$ksppi i, sys.x$ksppcv v
       where i.indx = v.indx;

  SQL> @param.sql
  SQL> exit