Re: Why some optimizer features are available in Oracle 8.0 and 9 but not in 8.1?

Home -> Community -> Usenet -> c.d.o.misc -> Re: Why some optimizer features are available in Oracle 8.0 and 9 but not in 8.1?

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 23 May 2003 22:34:04 +0200
Message-ID: <7b1tcvot8iemhqn051lg8ngr52d75igrdg@4ax.com>

On 23 May 2003 10:49:01 -0700, danielroy10_at_hotmail.com (Daniel Roy) wrote:

>I don't have access to all these database versions to double-check,
>but try to use the static view sys.x_$ksppi to see ALL the
>initialization parameters, including the "hidden" ones (the ones where
>the column KSPPINM starts with an underscore). I suspect that maybe
>these parameters were "hidden" in 8.1.

Which are of course the parameters Oracle advises in ALL their internal courses EXPRESSLY AGAINST changing them. And just FYI: these parameters are STILL hidden and to be left alone, unless you want have a different job.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri May 23 2003 - 15:34:04 CDT