this one works in oracle 7..
select rpad (a.indx ,10) "number"
, rpad (b.KSPPINM ,50) "name"
, rpad (a.KSPPSTVL,50) "value"
, rpad (a.KSPPSTDF,10) "default"
from x$KSPPCV a
, X$KSPPI b
where a.indx = b.indx
> ----------
> From: Surya Rao[SMTP:surya.rao_at_reuters.com]
> Sent: Thursday, June 22, 2000 23:05
> To: oracledba_at_quickdoc.co.uk
> Subject: Undocumented Parameter list and values
> Sensitivity: Confidential
>
> where can i find the list of undocumented parameters and
> their active values for an instance? They are not
> available from v$parameter or v$system_parameter or
> eve from "show parameter" from svrmgrl
>
> any resource where i can get a description of these
> parameters?
>
>
> _tia_
>
> surya
> -----
>
> -----------------------------------------------------------------
> Visit our Internet site at http://www.reuters.com
>
> Any views expressed in this message are those of the individual
> sender, except where the sender specifically states them to be
> the views of Reuters Ltd.
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Thu Jun 22 2000 - 03:27:27 CDT
