| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: extremely long parse time
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C2665B.92C0EF50"
------_=_NextPart_001_01C2665B.92C0EF50
Content-Type: text/plain;
charset="iso-8859-1"
Matt,
Is it Oracle 9?
If yes, time is in microseconds.
Alex.
-----Original Message-----
Sent: Thursday, September 26, 2002 10:30 AM
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.
------_=_NextPart_001_01C2665B.92C0EF50
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>extremely long parse time</TITLE>
<META content="MSHTML 5.00.3315.2870" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=781062519-27092002>Matt,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=781062519-27092002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=781062519-27092002>Is it
Oracle 9?</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=781062519-27092002>If
yes, time is in microseconds.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=781062519-27092002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=781062519-27092002>Alex.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=781062519-27092002></SPAN></FONT> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Adams, Matthew (GEA, MABG,
088130) [mailto:MATT.ADAMS_at_APPL.GE.COM]<BR><B>Sent:</B> Thursday, September
26, 2002 10:30 AM<BR><B>To:</B> Multiple recipients of list
ORACLE-L<BR><B>Subject:</B> extremely long parse time<BR><BR></DIV></FONT>
<P><FONT size=2>why would a query take 148 seconds to </FONT><BR><FONT
size=2>parse? It is a two way union </FONT><BR><FONT size=2>where the
first half is going against all_tables</FONT> <BR><FONT size=2>and the second
half is a join </FONT><BR><FONT size=2>between all_indexes and
all_ind_columns.</FONT> </P>
<P><FONT size=2>The shared pool has 50M large parts of it are</FONT> <BR><FONT
size=2>free. I generated a 10046 (level 12) trace, and I just </FONT><BR><FONT size=2>don't see anything out of whack, except of the </FONT><BR><FONT size=2>c=14868 in the PARSE #1 line.</FONT> </P><BR><BR><P><FONT size=2>----</FONT> <BR><FONT size=2>Matt Adams - GE Appliances - matt.adams_at_appl.ge.com</FONT> <BR><FONT size=2>Their fundamental design flaws are completely</FONT> <BR><FONT size=2>hidden by their superficial design flaws.</FONT> <BR><FONT
------_=_NextPart_001_01C2665B.92C0EF50--
------=_NextPartTM-000-9450062e-d233-11d6-984b-0008c79fc2b3--
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Alexander.Feinstein_at_mitchell1.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 Fri Sep 27 2002 - 15:28:28 CDT
 |
 |