I have removed the mod() function and 'am using 'IF' condition.

Deleting 4000 records seems to take over 2 hours. The deletion happens on a partition of a table.

In the v$session, I see one session as inactive. Is this causing any problem
Badrinath