Hi,

I have an issue with one of the insert queries which is performing very bad.

This query is suppose to insert 6.5 million rows but since last 6 hours it has inserted only 600K rows.

Please see the excerpt from v$sqlstats

DISK_READS DIRECT_WRITES ROWS_PROCESSED USER_IO_WAIT_TIME

505082 0 620288 14661318963
I am sure user_io_wait_time is very very high. I am working on to figure out where it is waiting such a long time. Any hints to drive me in the right direction will be much appreciated.

Table current volume - 157 million
Partitioned - Y
No. of Indexes - 2 (1 local part. & 1 global hash part.)

Thanks,