Re: "'Resultcache" effect in ??

From: GD <>
Date: Fri, 24 Jul 2009 09:03:34 +0200
Message-ID: <h4bmc6$2pn$>

jlchiappa wrote:
> Im seeing this behavior in a coleague database : the original
> EE db was upgraded to EE in the same Solaris 9 box (big one,
> with 32 processors and 64 Mb of RAM), and since then, for big and
> complexes queries (ie, with subqueries, and/or views from views,
> inline views, WITH clause, the hairy ones) the first execution is
> 'slow', say, 15 minutes or alike, and the second execution is 5 times
> or so faster (say 3 minutes or alike). The details :

Dynamic sampling taking place at first parse? Received on Fri Jul 24 2009 - 02:03:34 CDT

Original text of this message