Hi Pando,

Nice to see you back after long time.

OS is HP-UX B.11.31

Actually, I have this problem with 6 out of 120 Informatica sessions. Out of these 6, five will do insert and one will do update.

The other tables residing in the same TS doesn't have any problem. Please see the out put from v$event_histogram.


Code:
    EVENT# EVENT                                                            WAIT_TIME_MILLI WAIT_COUNT
---------- ---------------------------------------------------------------- --------------- ----------
       116 db file sequential read                                                        1  609165281
       116 db file sequential read                                                        2   66522697
       116 db file sequential read                                                        4   93727756
       116 db file sequential read                                                        8  296013939
       116 db file sequential read                                                       16  170110709
       116 db file sequential read                                                       32   44205035
       116 db file sequential read                                                       64   21820058
       116 db file sequential read                                                      128    7420962
       116 db file sequential read                                                      256    2801755
       116 db file sequential read                                                      512    1270400
       116 db file sequential read                                                     1024     383451
       116 db file sequential read                                                     2048      91451
       116 db file sequential read                                                     4096       2047
       116 db file sequential read                                                     8192        128
       116 db file sequential read                                                    16384         21
       116 db file sequential read                                                    32768          5
Thanks,