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

Home -> Community -> Mailing Lists -> Oracle-L -> Delete statement is very slow !!

Delete statement is very slow !!

From: Reddy, Madhusudana <Madhusudana.Reddy_at_bestbuy.com>
Date: Sun, 03 Aug 2003 09:34:23 -0800
Message-ID: <F001.005C89F4.20030803093423@fatcity.com>


Can someone explian me why this delete statement is very slow ?? any suggestions !!! pl find the details below !!

Thanks
Madhu

Statement:
++++++++
delete from <tabke_name> where eow_date<ADD_MONTHS(TO_DATE(:b0,'YYYYMMDD'),((-1)* :b1));

PLAN:
+++++

Plan Table


| Operation                 |  Name    |  Rows | Bytes|  Cost  | Pstart| Pstop |

--------------------------------------------------------------------------------
| DELETE STATEMENT | | 1M| 20M| 66106 | | | | DELETE |WIN_STORE | | | | | | | TABLE ACCESS BY GLOBAL I|WIN_STORE | 1M| 20M| 66106 | ROWID | ROW L | | INDEX RANGE SCAN |WIN_STORE | 1M| | 2616 | | |
--------------------------------------------------------------------------------

Session_IO:
+++++++++

11:27:49 SQL> @session_top_sql

OS User                        DB User                         SID # of UndoBlk     LOG IO     PHY IO HASH VALUE SQL ADDRESS
------------------------------ ------------------------------ ---- ------------ ---------- ---------- ---------- ----------------
batchusr                       RTKBATCH                         77 52349           6223101     987505 1253119663 C0000000BB3BC2B8


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Reddy, Madhusudana
  INET: Madhusudana.Reddy_at_bestbuy.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 Sun Aug 03 2003 - 12:34:23 CDT

Original text of this message

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