Re: Undocumented Init.Ora Parms

And to get their values:

            select KSPPINM, KSPPSTVL  ,KSPPDESC
            from sys.x_$ksppi ksppi, sys.x_$ksppcv ksppcv
            where substr(KSPPINM,1,1) ='_' and ksppi.indx = ksppcv.indx;

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, June 21, 2001 6:42 PM

> Jeremiah;
> First, thanks. NIce infor to have.
>
> Second, the first line works great on Solaris and Oracle 8.0.5.
>
> Third, the sql statement should actually be
> select KSPPINM, KSPPDESC from x$ksppi where substr(KSPPINM,1,1) =
> '_'
> Missed the ,1 parm off the substr.
>
> -----Original Message-----
> Sent: Thursday, June 21, 2001 5:01 PM
> To: Multiple recipients of list ORACLE-L
>
>
> This used to work on other platforms and versions, but my HP-UX 64 bit
> binary
> doesn't have any interesting strings any more:
>
> strings $ORACLE_HOME/bin/oracle | perl -ne 'print if /^_[a-z]+_[a-z]/' |
> sort | uniq
>
> The typical location for underscore parameters is x$ksppi:
>
> (as SYS:)
> select KSPPINM, KSPPDESC from x$ksppi where substr(KSPPINM,1) = '_';
>
> The event codes (most of them) are documented in
> $ORACLE_HOME/rdbms/mesg/oraus.msg, after error number 10000.
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> On Thu, 21 Jun 2001, Kevin Lange wrote:
>
> > Is there any place that has a list of ALL the things you can put into
> the
> > Init file and what they do ?? Not just the regular option strings....
I
> > can get a list of these from a couple of web sites , but all of the
hidden
> ,
> > and as far as I know, undocumented EVENT strings as well??
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeremiah Wilton
> INET: jwilton_at_speakeasy.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Lange
> INET: kgel_at_ppoone.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Schlossnagle
  INET: george_at_omniti.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).