RE: Long Parse Times, Huge In Lists
Date: Fri, 23 Oct 2009 13:09:46 -0500
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
> -----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
> 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.