Re: Compatible=8.1.0 vs compatible=8.1.7 diference

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Mon, 03 Nov 2003 18:08:13 -0600
Message-ID: <vqdrf41l8jcm65@corp.supernews.com>

Go to the following link:

http://download-east.oracle.com/docs/cd/A87860_01/doc/server.817/a76962/toc.htm

It details the new 8i features by version. Personally, I'd just set COMPATIBLE to 8.1.7 if that was the version I was running, unless I had a very specific reason *not* to.

HTH,
Brian

On Monday 03 November 2003 12:34, Guy Dallaire thoughtfully contributed:
> Is there any difference on using 8.1.7 instead of 8.1.0 ?
>
> I'm trying to figure out what features are 8.1.7-specific and cannot find
> anything useful on metalink or in the oracle doc.
>
> Right now, my instances are at 8.1.0 and I'm considering going to 8.1.7
> but I wanna make sure that it won't hurt performance. I know 8.1.7 should
> be set, but it might change the way the optimizer is choosing its
> execution plans. I can't find a document telling me WHY 8.1.7 should be
> set.
Received on Mon Nov 03 2003 - 18:08:13 CST