extremely long parse time

From: Adams, Matthew (GEA, MABG, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Thu, 26 Sep 2002 09:29:52 -0800
Message-ID: <F001.004DA39C.20020926092952@fatcity.com>

Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C26579.6A375BBA" ------_=_NextPart_001_01C26579.6A375BBA
Content-Type: text/plain;
charset="iso-8859-1"

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.

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com Their fundamental design flaws are completely hidden by their superficial design flaws.

Douglas Adams

------_=_NextPart_001_01C26579.6A375BBA
Content-Type: text/html;
charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2655.35">
<TITLE>extremely long parse time</TITLE>
</HEAD>
<BODY>

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.

 
 

----
 Matt Adams - GE Appliances - matt.adams_at_appl.ge.com
 Their fundamental design flaws are completely
 hidden by their superficial design flaws.
           - Douglas Adams


</BODY>
</HTML>

------_=_NextPart_001_01C26579.6A375BBA--

------=_NextPartTM-000-59abd076-c9ca-4a45-8ab8-cc76c3fc2a3f--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Adams, Matthew (GEA, MABG, 088130)
  INET: MATT.ADAMS_at_APPL.GE.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_at_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).

Received on Thu Sep 26 2002 - 12:29:52 CDT