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

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance 7.3.3 vs. 8.0.5

Re: Performance 7.3.3 vs. 8.0.5

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Wed, 17 Nov 1999 13:53:43 GMT
Message-ID: <3832B367.7C5941BD@edcmail.cr.usgs.gov>


Oracle 8.0.5 has a different Optimizer than Oracle 7. As a result, it's not uncommon to see some queries run faster (or slower) when changing versions. Are you running CBO or RBO? Have you analyzed your tables? These are all considerations.

HTH,
Brian

Connor McDonald wrote:
>
> Volker Hauswurz wrote:
> >
> > Hi,
> > we migrated a database from 7.3.3 to 8.0.5. and ran our script which
> > performs our most used SQL-statements.
> > Both databases are on the same machine, use it exclusively and use a SGA
> > of same size, all other parameters are equal.
> >
> > Our script needs about 8 seconds on 7.3.3 and about 13 seconds on 8.0.5
> > :-(
> >
> > Any hints? Other observations for 8.0.6?
> >
> > Thanks
> > Volker
>
> Did you run it multiple times to ensure it wasn't a parsing issue?
>
> Other than that, turn trace on and see what differences (if any) there
> were on the explain plans...
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."
Received on Wed Nov 17 1999 - 07:53:43 CST

Original text of this message

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