Re: Undocumented parameter values

From: F Lange <flange_at_pt.lu>
Date: 1997/07/03
Message-ID: <01bc87eb$ccaa2be0$7ad79ac2@LangeFrancois>#1/1

Hi,

        Version previously to 7.3

                select * from x$ksppi ;

        After look at 7.3

                The table has been splited in 2 tables.

select x.indx+1,ksppinm,ksppity,ksppstvl,ksppstdf, decode(bitand(ksppiflg/256,1),1,'TRUE','FALSE'),   decode(bitand(ksppiflg/65536,3),1,'IMMEDIATE',2,'DEFERRED','FALSE'),

decode(bitand(ksppstvf,7),1,
'MODIFIED',4,'SYSTEM_MOD','FALSE'), 
decode(bitand(ksppstvf,2),2,'TRUE','FALSE'),   ksppdesc from x$ksppi x,

x$ksppcv y where x.indx = y.indx ;

Regards Francois.
Motley Crue <chuacl_at_iscs.nus.edu.sg> wrote in article <5pcu65$ebg_at_nuscc.nus.sg>...
> Anyone has any idea which of the x$* tables stores the value of
 undocumented
> parameters for init.ora? The table x$ksppi stores the parameter name but
 the
> table doesn't seem to have a value column. TIA.
>
> --
> Choon Leong
>
  Received on Thu Jul 03 1997 - 00:00:00 CDT