Re: _* initialization parameters

From: Michael Sun <mikeny31_at_speakeasy.org>
Date: Mon, 8 May 2000 09:48:43 -0400
Message-Id: <10491.105164@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>_* initialization parameters</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>1) On Steve Adam's site <A=20
href=3D"http://www.ixora.com.au/">http://www.ixora.com.au/</A>, there is = a script=20
called hidden_parameters.sql. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>2) Query X$KSPPI with the following=20
statement</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>set linesize 132<BR>select=20
substr(KSPPINM,1,40)"PARAMETER",<BR>substr(KSPPSTVL,1,15)"VALUE",<BR>subs= tr(KSPPDESC,1,60)"DESCRIPTION"<BR>from=20 x$ksppi x, x$ksppcv y where x.INDX =3D y.INDX<BR>and substr(KSPPINM,1,1) = =3D=20
'_'<BR>order by KSPPINM ;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Michael<BR></DIV></FONT>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A href=3D"mailto:benhayoune_at_maroclear.co.ma"=20   title=3Dbenhayoune_at_maroclear.co.ma>Benhayoune khalid</A> </DIV>   <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Monday, May 08, 2000 7:34 =
AM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> _* initialization=20

parameters</DIV>

  <DIV><BR></DIV>
  <P><FONT face=3DArial size=3D2>Excuse my poor English !</FONT> </P>
  <P><FONT face=3DArial size=3D2>Does someone knows were can i find =

documentation on=20
  _* Oracle initialization parameters (eg : _disable_logging).</FONT> =
</P>

  <P><FONT face=3DArial size=3D2>Thank you in advance.</FONT> </P>   <P><FONT face=3DArial=20
  =

size=3D2>----------------------------------------------------------------=

--</FONT>=20
  <BR><FONT face=3DArial size=3D2>K.Benhayoune</FONT> <BR><FONT = face=3DArial=20
  size=3D2>System engineer/DBA</FONT> <BR><FONT face=3DArial = size=3D2>MAROCLEAR</FONT>=20
  <BR><FONT face=3DArial size=3D2>Phone : 212-2-48-49-49</FONT> =
<BR><FONT face=3DArial=20

  size=3D2>Fax : 212-2-48-67-03</FONT> <BR><FONT face=3DArial = size=3D2>Address : 216,=20
  BD ZERKTOUNI, 5 eme etage</FONT> <BR><FONT face=3DArial=20   =
size=3D2>          &nbs= p;  =20 Received on Mon May 08 2000 - 08:48:43 CDT