Insert performance is very bad
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
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.
DISK_READS DIRECT_WRITES ROWS_PROCESSED USER_IO_WAIT_TIME
505082 0 620288 14661318963
Table current volume - 157 million
Partitioned - Y
No. of Indexes - 2 (1 local part. & 1 global hash part.)
Try hard to get what you like OR you will be forced to like what you get.