Hidden database parameters

[Daniel Trickett]

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

[Howard J. Rogers]

select * from sys.x$ksppi should do it.

Regards
HJR

"Daniel Trickett" <Daniel....@oracle.com> wrote in message
news:PGD59.93780$uj.5...@rwcrnsc51.ops.asp.att.net...

[M. Stoddard]

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....@oracle.com> wrote in message
news:PGD59.93780$uj.5...@rwcrnsc51.ops.asp.att.net...