Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: 8i to 9i migration, performance issues
> Do we loose features of 9i, if we set this parameter?
> optimizer_feature_enable=817
>
> CBO in 9i is different then CBO in 8i?
>
By looking at http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch1136.htm#1020706, here's what you lose by setting optimizer_feature_enable to 817:
Only you (and your developers) know if you care or not about these features. I personally don't think it's a good idea to invest on a database upgrade, and then on purpose try to avoid the new features. I would instead take a look closer at one of the queries running slowly, to see what's the cause.
Just my 2 cents
Daniel Received on Fri Mar 12 2004 - 12:52:57 CST
![]() |
![]() |