Re: Performance 7.3.3 vs. 8.0.5

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 16 Nov 1999 18:45:39 +0800
Message-ID: <383135D3.3E74@yahoo.com>

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 Tue Nov 16 1999 - 04:45:39 CST