Re: 8i to 9i migration, performance issues

More wrote:

> Do we loose features of 9i, if we set this parameter?
> optimizer_feature_enable=817
>
> CBO in 9i is different then CBO in 8i?
>
> Thanks,

You lose access to all of those things added to 9i that were not in 8i.

I wouldn't do it ... I'd tune the code.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)