Performance issue
Posted: Wed Dec 06, 2006 4:32 pm
Hello sir,
I am loading 12 million records of a mainframe COBOL file having 800 record length into a Oracle 9i table.
In that file we have lot of comp3 fields and comp fields.In the transformer i used data type convertions to split into columns.
Every thing looks good.
But i am getting performance issues.
I tested with Oracle normal and bulk loads.It is taking around 81/2 hours.
Can you please help me out on this performance issue.
Thanks in advance.
Reddy
I am loading 12 million records of a mainframe COBOL file having 800 record length into a Oracle 9i table.
In that file we have lot of comp3 fields and comp fields.In the transformer i used data type convertions to split into columns.
Every thing looks good.
But i am getting performance issues.
I tested with Oracle normal and bulk loads.It is taking around 81/2 hours.
Can you please help me out on this performance issue.
Thanks in advance.
Reddy