Thanks Stecal.

you could have lost the bet if you bet. Informatica construct the insert with bind variables. The values part of my bad insert query looks like below.

Code:
VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17)
That table has only two Indexes and as I mentioned earlier both of them are partitioned. One is local and other one is global. However, I will keep this in mind and drop the Indexes during next load.

Please see my instance efficiency percentages.

Code:
Instance Efficiency Percentages
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:  100.00       Redo NoWait %:  100.00
            Buffer  Hit   %:   95.87    In-memory Sort %:   99.99
            Library Hit   %:   88.93        Soft Parse %:   86.47
         Execute to Parse %:   58.98         Latch Hit %:   99.94
Parse CPU to Parse Elapsd %:   65.59     % Non-Parse CPU:   99.95
Thanks,