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

Home -> Community -> Usenet -> c.d.o.server -> Re: mass deletes

Re: mass deletes

From: chao_ping <zhuchao_at_gmail.com>
Date: 9 May 2005 03:19:25 -0700
Message-ID: <1115633965.759010.162070@o13g2000cwo.googlegroups.com> 





CTAS is not always an option as many site use delete to archive the old
history data.


 Parallel dml maybe is a good choice.



I would suggest:


1. Enable SQL trace to see if oracle is doing table scan for the
related tables to find whether there is rows in child table (If you are
deleting from parent table).


2. Check the SQL execution plan ifi there is possibility to tune it.
Received on Mon May 09 2005 - 05:19:25 CDT












Original text of this message













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