Insert performance is very bad

[vnktummala]

I have enabled the trace in the session for more than one hour, before it complete few minutes back. Please see the wait events from tkprof trace file.

VALUES
 ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17)
   


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute   2779     97.96    2741.65      79587      93439    1966341      622496
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     2779     97.96    2741.65      79587      93439    1966341      622496

Misses in library cache during parse: 0
Misses in library cache during execute: 1
Optimizer mode: CHOOSE
Parsing user id: 83  

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net more data from client               22614        0.00          0.21
  db file sequential read                     79403        1.38       1861.02
  SQL*Net message to client                    2778        0.00          0.00
  SQL*Net message from client                  2778        0.00          1.96
  latch: object queue header operation            1        0.00          0.00
  log file switch completion                      2        0.51          0.51
  log file sync                                   3        0.00          0.00

based on 'db file sequential read' waits, am I correct If I conclude that there is an issue with the Indexe(s) on the table in question?


Thanks,