Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Why does a simple delete takes 12 hours and longer ?

Why does a simple delete takes 12 hours and longer ?

From: Andreas Jung <ajung_at_sz-sb.de>
Date: Fri, 28 Jul 2000 09:21:35 +0200
Message-Id: <10572.113198@fatcity.com> 





Yesterday evening I started the following delete:



delete from ojs_main_multiple where docnum not in (select docnum from ojs_main);



ojs_main contains about 250.000 rows and ojs_main_multiple about 300.000 rows.
docnum is a unique primary key of ojs_main. This morning after about 12 hours
the delete was still running. Any idea  why this happens ? Should I believe
in "In Oracle we trust "?



(our env.: Oracle 8i EE/Solaris on a Sun E450 with 4 CPUs)



Andreas
Received on Fri Jul 28 2000 - 02:21:35 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US