RE: Why does a simple delete takes 12 hours and longer ?

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Sun, 30 Jul 2000 13:23:41 -0400
Message-Id: <10574.113317@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFFA4A.EBA76EE0
Content-Type: text/plain;

charset="iso-8859-1"

I think first you need to know the product ( Oracle in this case ) and then make a judgement about quality of it.

Alex Hillman

-----Original Message-----
From: Andreas Jung [mailto:ajung_at_sz-sb.de] Sent: Friday, July 28, 2000 3:01 PM
To: Multiple recipients of list ORACLE-L Subject: Re: Why does a simple delete takes 12 hours and longer ?

On Fri, Jul 28, 2000 at 09:39:29AM -0800, Lyall Barbour wrote:
> Well, if everything was initialized in the beginning as far as the
init.ora
> file goes, you're probably doing a Nested Loop anti-join. I'd suggest
> inserting ALWAYS_ANTI_JOIN=HASH (or MERGE)
>
> Just a little tip from your Uncle Lyall!
>
> Of course to do this.... do you need a bounce, or can you do ALTER
> SESSION.... I think you can do alter session. I know you can use a hint
in
> your delete /*+ HASH_AJ */

*sigh* Oracle is a beast and CBO should be renamed to "Confusing Bastard Optimizer"

Andreas

-- 
Author: Andreas Jung
  INET: ajung_at_sz-sb.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

------_=_NextPart_001_01BFFA4A.EBA76EE0
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.2448.0">
<TITLE>RE: Why does a simple delete takes 12 hours and longer ?</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>I think first you need to know the product ( Oracle in this case ) and then make a judgement about quality of it.</FONT>
</P>

<P><FONT SIZE=2>Alex Hillman</FONT>
</P>

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Andreas Jung [<A HREF="mailto:ajung_at_sz-sb.de">mailto:ajung_at_sz-sb.de</A>]</FONT>
<BR><FONT SIZE=2>Sent: Friday, July 28, 2000 3:01 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: Re: Why does a simple delete takes 12 hours and longer ?</FONT>
</P>
<BR>

<P><FONT SIZE=2>On Fri, Jul 28, 2000 at 09:39:29AM -0800, Lyall Barbour wrote:</FONT>
<BR><FONT SIZE=2>&gt; Well, if everything was initialized in the beginning as far as the init.ora</FONT>
<BR><FONT SIZE=2>&gt; file goes, you're probably doing a Nested Loop anti-join.&nbsp; I'd suggest</FONT>
<BR><FONT SIZE=2>&gt; inserting ALWAYS_ANTI_JOIN=HASH (or MERGE)</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; Just a little tip from your Uncle Lyall!</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; Of course to do this.... do you need a bounce, or can you do ALTER</FONT>
<BR><FONT SIZE=2>&gt; SESSION....&nbsp; I think you can do alter session.&nbsp; I know you can use a hint in</FONT>
<BR><FONT SIZE=2>&gt; your delete /*+ HASH_AJ */</FONT>
</P>

<P><FONT SIZE=2>*sigh* Oracle is a beast and CBO should be renamed to</FONT>
<BR><FONT SIZE=2>&quot;Confusing Bastard Optimizer&quot;</FONT>
</P>

<P><FONT SIZE=2>Andreas </FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Andreas Jung</FONT>
<BR><FONT SIZE=2>&nbsp; INET: ajung_at_sz-sb.de</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>

Received on Sun Jul 30 2000 - 12:23:41 CDT