Xref: alice comp.databases.oracle.server:24195
Path: alice!news-feed.fnsi.net!news.idt.net!nntprelay.mathworks.com!cam-news-hub1.bbnplanet.com!cam-news-feed1.bbnplanet.com!news.bbnplanet.com!news2.gte.com!news.gte.com!not-for-mail
From: "Kevin Brand" <kbrand@sequel.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Large Parse times
Date: 8 Jul 1998 02:18:51 GMT
Organization: Brand Consulting, Inc
Lines: 19
Message-ID: <01bdaa16$6086eea0$fc7f3f8f@khome.gtetel.com>
References: <6nufp0$u0o$1@nnrp1.dejanews.com>
X-Newsreader: Microsoft Internet News 4.70.1155



I found that large, multi-table ( 8+ ) joins can sometimes take enormous
amount of time in parse phase.  This was true only after an import, which
ESTIMATES statistics,  and before a full COMPUTE statistics on V7333/AIX. 
Most of the parse time, though, was spent waiting on Library Cache enqueue.

-Kevin

pbolduc@online-can.com wrote in article
<6nufp0$u0o$1@nnrp1.dejanews.com>...
> 
> 
> Platform: HP/UX
> Oracle Version: 7.3.2.2.0
> 
> We have some queries that seem to have exceesive parse times:
>