Re: Oracle7 init.ora undocumented parameters?

From: Heggelund <d92hegge_at_ix_prod.hfk.mil.no>
Date: 1997/04/03
Message-ID: <1997Apr3.072649.9231@ix_prod.hfk.mil.no>#1/1

Hi,
in 7.3 the column ksppivl has moved to the fixed table x$ksppcv. In x$ksppi they have added a description column which might be useful.

A query like this will work in 7.3:

select x.ksppinm
,      x.ksppdesc
,      y.ksppstvl
from   x$ksppcv y
,      x$ksppi  x

where x.indx = y.indx
order by 1
/

Rgds
Steinar Heggelund

Naren Chintala (naren_at_mink.att.com) wrote:
: squinn_at_netcomuk.co.uk wrote:
: >
: > Anybody got a list and description of the undocumented init.ora
: > parameters for ORACLE7? (The ones beginning with _)
 

: Connect as SYS and execute the following query
 

: SQL> select KSPPINM,KSPPIVL from x$ksppi;
 

: This works on Oracle 7.2.3.
: --
: Naren

--

----------------------------------------------------------------------------
I'm employed in the Norwegian consulting company Opus One AS. 
I have 7 years experience with Oracle products, mainly the database. 
We are a small company which offers consulting services in design,
implementation and tuning of databases and applications based on Oracle.

Received on Thu Apr 03 1997 - 00:00:00 CST