Insert performance is very bad

[vnktummala]

Is there any way to find so far how many times the given Insert query is issued commit? In Informatica session commit interval is set for every 20000 rows but just want to cross check that.

Also, can any one shed some light why INSERT session is waiting on "db file sequential read" which is usually for single block reads like index reads.

I have generated the stats pack report (no license for performance pack) from 11th Nov 10pm to 12th Nov 2am and please see the top 5 wait events below.

Top 5 Timed Events                                                    Avg %Total
~~~~~~~~~~~~~~~~~~                                                   wait   Call
Event                                            Waits    Time (s)   (ms)   Time
----------------------------------------- ------------ ----------- ------ ------
CPU time                                                    70,287          60.9
db file sequential read                      2,962,799      34,443     12   29.8
enq: CI - contention                             1,276       3,590   2813    3.1
db file scattered read                         322,883       1,879      6    1.6
rdbms ipc reply                                  1,283       1,721   1341    1.5
          -------------------------------------------------------------

Please Note - only 2 very bad Insert queries are executing in the database during this time.


Thanks,