Envelope-to: oracle-l@orafaq.net
Delivery-date: Fri, 27 Sep 2002 01:44:39 +0800
Message-ID: <F001.004DA565.20020926103627@fatcity.com>
Date: Thu, 26 Sep 2002 10:36:27 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Jesse, Rich" <Rich.Jesse@qtiworld.com>
Subject: RE: extremely long parse time
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Perhaps optimizer_max_permutations may be worth taking a look at?

Rich Jesse                              System/Database Administrator
Rich.Jesse@qtiworld.com                 Quad/Tech International, Sussex, WI
USA

-----Original Message-----
Sent: Thursday, September 26, 2002 12:30 PM
To: Multiple recipients of list ORACLE-L


why would a query take 148 seconds to 
parse?  It is a two way union 
where the first half is going against all_tables 
and the second half is a join 
between all_indexes and all_ind_columns. 
The shared pool has 50M large parts of it are 
free.  I generated a 10046 (level 12) trace, and I just 
don't see anything out of whack, except of the 
c=14868 in the PARSE #1 line. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse@qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).