RE: Long Parse Times, Huge In Lists
From: Larry G. Elkins <elkinsl_at_flash.net>
Date: Fri, 23 Oct 2009 13:09:46 -0500
Message-ID: <004c01ca540c$0185ff20$0491fd60$_at_net>
Good pointer. Didn't hit that one yet on Metalink, though I came across a discussion of the possible related bug refrenced by the note when reading one of Poder's blog entries. Anyway, I'll take a look at experimenting with the optimizer_or_expansion parameter.
Date: Fri, 23 Oct 2009 13:09:46 -0500
Message-ID: <004c01ca540c$0185ff20$0491fd60$_at_net>
Good pointer. Didn't hit that one yet on Metalink, though I came across a discussion of the possible related bug refrenced by the note when reading one of Poder's blog entries. Anyway, I'll take a look at experimenting with the optimizer_or_expansion parameter.
Larry G. Elkins
elkinsl_at_flash.net
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of D'Hooge Freek
> Sent: Friday, October 23, 2009 12:54 PM
> To: elkinsl_at_flash.net; oracle-l_at_freelists.org
> Subject: RE: Long Parse Times, Huge In Lists
>
> Hi,
>
> Check out metalink note: Doc ID: 744664.1- High Parse Time and Memory
> Usage for Query with Complex OR Predicates or IN-Lists After Upgrade to
> 10.2 or 11.1.
>
> I came accross it on one of our client sites.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 23 2009 - 13:09:46 CDT