Re: Hidden database parameters

From: M. Stoddard <stoddard_at_tds.net>
Date: Mon, 12 Aug 2002 01:27:59 GMT
Message-ID: <zaE59.993$Hr.644094@kent.svc.tds.net>

This works for Oracle 8i. Run it as sys. Remember to set pause off when you're done as it can be a nuisance.

• Martin

set verify off
set pagesize 36
set linesize 132
set pause on
set pause 'Hit enter to continue'
set feedback off
set showmode off
set echo off
column pname format a32 heading 'Name'; column pval format a32 heading 'Value' word_wrapped; column deflt format a7 heading 'Default|value?'; column pdesc format a48 heading 'Description' word_wrapped;

select ksppinm pname,

       ksppstvl pval,
       ksppstdf deflt,
       ksppdesc  pdesc
  from  x$ksppi x,
        x$ksppsv y

 where x.indx = y.indx
order by
decode(substr(ksppinm,1,1),'_',substr(ksppinm,2,length(ksppinm)-1),ksppinm) /

"Daniel Trickett" <Daniel.Trickett_at_oracle.com> wrote in message news:PGD59.93780$uj.54786_at_rwcrnsc51.ops.asp.att.net...
> Hi,
>
> I found something a while back on which view/table contains the hidden
> database parameters
> in Oracle 8i. Now when I need it, I can't remember what the name was...
>
> Can anyone help out on this ? Thanks in advance...
>
> Dan
>
>
Received on Sun Aug 11 2002 - 20:27:59 CDT