Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: performance in 10g

Re: performance in 10g

From: David Boyd <davidb158_at_hotmail.com>
Date: Thu, 25 Jan 2007 09:31:34 -0500
Message-ID: <BAY101-F320DA1BB5AEB32AE8BF7A9EFA30@phx.gbl>


We're still testing queries in dev. The execution plan is much different between 9i and 10g. We see a lot more full table scan in 10g/CBO than 9i/RBO.

>Maybe I'm missing sonething here (no coffee yet). You say that you tested
>your upgrade under 10g. Now some of the queries that were okay in test are
>not good in production?
> Just a dumb idea, couldn't you inspect the query plan for those
>queries
>to get an idea of how they differ, maybe there is a single table involved
>or
>something.
> Anyway, there are people with FAR better SQL tuning knowledge on this
>list than I so please listen to them, but this might be something to check
>into in the meantime.
>
>Dennis Williams



From predictions to trailers, check out the MSN Entertainment Guide to the Academy Awards®
http://movies.msn.com/movies/oscars2007/?icid=ncoscartagline1
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 25 2007 - 08:31:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US