Re: Undocumented INIT parameters

In article <3A51F1EC.EE52CABF_at_edcmail.cr.usgs.gov>,   Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:
> You can run this script:
>
> select
> x.ksppinm name,
> decode(bitand(ksppiflg/256,1),1,'TRUE','FALSE') sesmod,
> decode(
> bitand(ksppiflg/65536,3),
> 1,'IMMEDIATE',
> 2,'DEFERRED',
> 3,'IMMEDIATE',
> 'FALSE'
> ) sysmod,
> ksppdesc description
> from
> sys.x$ksppi x
> where
> x.inst_id = userenv('Instance') and
> translate(ksppinm,'_','#') like '#%'
> order by 1;
>
> You must run this script as SYS!
>
> In all fairness, this script is not mine. I copied it from Steve
 Adams'
> web site (http://www.ixora.com.au) and made one very slight
 modification
> for it to work. This script will show you the undocumented INIT.ORA
> parameters with a description of each!
>
> HTH,
> Brian
>
> Younes naguib wrote:
> >
> > Hi,
> > Is there anyway to have a list and some description for oracle
> > undocumented parameters and features?
> >
> > NY
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
>

These are also listed in Appendix A of "Oracle Performance Tuning Tips & Techniques" (Oracle Press, Richard Niemiec).

Matt.

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 02 2001 - 16:41:23 CST