Thanks Ales.

There are 2 SQL's (one DELETE & one INSERT) taking 5 hours in one process.

The Delete query is taking 2 and half hours which is deleting 26 million rows from the table (Total 41 million rows), which is performing a full table scan with.

The wait event for this query is "db file sequential read" even though it is a FTS.

-----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)|
-----------------------------------------------------------------------------
| 0 | DELETE STATEMENT | | 26M| 2141M| 127K (2)|
| 1 | DELETE | PS_COMBO_DATA_TBL | | | |
|* 2 | TABLE ACCESS FULL| PS_COMBO_DATA_TBL | 26M| 2141M| 127K (2)|
-----------------------------------------------------------------------------

Regards
Srini