Re: Undocumented INIT parameters

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Tue, 2 Jan 2001 15:21:16 GMT
Message-ID: <3A51F1EC.EE52CABF@edcmail.cr.usgs.gov>

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!
========================================

Received on Tue Jan 02 2001 - 09:21:16 CST