Message-Id: <10491.105164@fatcity.com> From: "Michael Sun" Date: Mon, 8 May 2000 09:48:43 -0400 Subject: Re: _* initialization parameters This is a multi-part message in MIME format. ------=_NextPart_000_0220_01BFB8D2.98EBDAE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable _* initialization parameters1) On Steve Adam's site = http://www.ixora.com.au/, there is a script called = hidden_parameters.sql.=20 2) Query X$KSPPI with the following statement =20 set linesize 132 select substr(KSPPINM,1,40)"PARAMETER", substr(KSPPSTVL,1,15)"VALUE", substr(KSPPDESC,1,60)"DESCRIPTION" from x$ksppi x, x$ksppcv y where x.INDX =3D y.INDX and substr(KSPPINM,1,1) =3D '_' order by KSPPINM ; Michael ----- Original Message -----=20 From: Benhayoune khalid=20 To: Multiple recipients of list ORACLE-L=20 Sent: Monday, May 08, 2000 7:34 AM Subject: _* initialization parameters Excuse my poor English !=20 Does someone knows were can i find documentation on _* Oracle = initialization parameters (eg : _disable_logging).=20 Thank you in advance.=20 ------------------------------------------------------------------=20 K.Benhayoune=20 System engineer/DBA=20 MAROCLEAR=20 Phone : 212-2-48-49-49=20 Fax : 212-2-48-67-03=20 Address : 216, BD ZERKTOUNI, 5 eme etage=20 Casablanca (Morocco)=20 ------=_NextPart_000_0220_01BFB8D2.98EBDAE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable _* initialization parameters
1) On Steve Adam's site http://www.ixora.com.au/, there is = a script=20 called hidden_parameters.sql.
 
2) Query X$KSPPI with the following=20 statement
 
set linesize 132
select=20 substr(KSPPINM,1,40)"PARAMETER",
substr(KSPPSTVL,1,15)"VALUE",
subs= tr(KSPPDESC,1,60)"DESCRIPTION"
from=20 x$ksppi x, x$ksppcv y where x.INDX =3D y.INDX
and substr(KSPPINM,1,1) = =3D=20 '_'
order by KSPPINM ;
 
Michael
----- Original Message -----
From:=20 Benhayoune khalid
To: Multiple recipients of list ORACLE-L =
Sent: Monday, May 08, 2000 7:34 = AM
Subject: _* initialization=20 parameters

Excuse my poor English !

Does someone knows were can i find = documentation on=20 _* Oracle initialization parameters (eg : _disable_logging). =

Thank you in advance.

----------------------------------------------------------------= --=20
K.Benhayoune
System engineer/DBA
MAROCLEAR=20
Phone : 212-2-48-49-49 =
Fax : 212-2-48-67-03
Address : 216,=20 BD ZERKTOUNI, 5 eme etage
          &nbs= p;  =20