Performance Problems with Ora 7.33

From: Uwe Schneider <uwe.schneider_at_xlink.net>
Date: Thu, 05 Nov 1998 13:00:49 +0100
Message-ID: <36419371.ED5B3F7E@xlink.net>

Hi,

after finally finished upgrading from Oracle 7.23 to 7.3.3 we are experiencing dramatical performance decays with queries, esp. with complex joins which used to run flawlessly.

This means e.g. that some programs which used to finish in 10 seconds now run for hours (with full cpu contention on the server). Other programs even trigger a timeout and don't even work anymore.

Can somenody give me a hint what we can do, or what we could have done wrong?

(After upgrading the server software I did upgrade the database objets.)

In deperate mood

Uwe Received on Thu Nov 05 1998 - 06:00:49 CST