Re: Performance Problems with Ora 7.33

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Thu, 5 Nov 1998 12:25:23 -0600
Message-ID: <71sqmo$fm3$1@news.gte.com>

I'd patch to 7.3.3.6 if you're not running OPS, 7.3.3.3 if you are.

Also, setting OPTIMIZER_GOAL=FIRST_ROWS in your session for testing and finally instance wide in the init file with OPTIMIZER_MODE=FIRST_ROWS, will minimize the use of HASH joins, which will minimize the potential of CBO choosing full table scans in error.

-Kevin

remove the x for an email reply
Uwe Schneider wrote in message <36419371.ED5B3F7E_at_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 - 12:25:23 CST