Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Delete statement is very slow !!
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
![]() |
![]() |