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

From: Anne Yu <AYu_at_sos.state.tx.us>
Date: Tue, 1 Aug 2000 08:21:37 -0500
Message-Id: <10576.113474@fatcity.com>

Thanks Dan, Good point!

-----Original Message-----
From: dan williams [mailto:2dwilliams_at_excite.com] Sent: Monday, July 31, 2000 11:31 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Why does a simple delete takes 12 hours and longer ?

One reason for the slow delete would be how many indexes are involved, and the time to rebuild the various indexes. In addition to the SQL statement that have already been addressed.

On Sun, 30 Jul 2000 11:05:15 -0800, ORACLE-L_at_fatcity.com wrote:

> Hi!
>
> sorry if I am joining in later after the solution.
>
> But the
> following query
>
> delete from ojs_main_multiple where docnum not in (select docnum from
> ojs_main);
> >
> > --
> > 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).
>
>
> Regards
> Rajagopal Venkataramany
>
>
>
>
>
> _______________________________________________________
> Say Bye to Slow Internet!
> http://www.home.com/xinbox/signup.html
>
> --
> Author: Rajagopal Venkataramany
> INET: rajagopalvr_at_excite.com
>
> 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).
>
>
> ______________________________________________
> FREE Personalized Email at Mail.com
> Sign up at http://www.mail.com/?sr=signup
>
> --
> Author: Cyril Thankappan
> INET: cyril_thank_at_india.com
>
> 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).

---

Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html

-- 
Author: dan williams
  INET: 2dwilliams_at_excite.com

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

Received on Tue Aug 01 2000 - 08:21:37 CDT