Re: Ora-3113 when executing a complex query!

From: GigioTD <gigiotd_at_gmail.com>
Date: 23 Feb 2007 02:27:50 -0800
Message-ID: <1172226470.609049.289060@z35g2000cwz.googlegroups.com>

On 22 Feb, 23:30, "joel garry" <joel-ga..._at_home.com> wrote:
> Are you getting any trace files?

Nothing... existing .trc files are old.

>Do you have any limits set for user
> processes?

I don't think... what do you mean exactly?

>What platform are you on?

MS Win server 2003 std, Oracle 9.2.0.5.

> Do you have
> query_rewrite_enabled set?

No, should I set this parameter to TRUE? Actually it's FALSE.

> Could be a bug too: See bug 3561624 ORA-3113 WITH > 17M
> HASH_AREA_SIZE AND WORKAREA_SIZE_POLICY SET TO MANUAL and poke about
> in the later 9.2 lists of fixed bugs.

Uhm... I don't have matalink access.... :°°°(

Thanks!
Bye Received on Fri Feb 23 2007 - 04:27:50 CST