Using ORACLE PARALLEL DML on OCI Stage
Posted: Wed Apr 16, 2003 9:09 am
Hi my problem is this :
I must load a large volumes of data from a flat file into an Oracle Table directly (without a transformer stage) like this :
[FLAT FILE]-------------------->[OCI8]
I try to use an Oracle HINT directive into the Before page and into the SQL-User Defined page of stage:
[BEFORE PAGE] : ALTER SESSION ENABLE PARALLEL DML
[SQL-USER DEFINED] : INSERT /*+APPEND PARALLEL (BULK,5)*/ INTO ......
During the execution of job I monitored the sessions opened on Oracle server end I verify the only one session was opened.
What is the rigth way to use the PARALLEL DML feature of ORACLE 9.x?
Thanks a lot.
by[?]
I must load a large volumes of data from a flat file into an Oracle Table directly (without a transformer stage) like this :
[FLAT FILE]-------------------->[OCI8]
I try to use an Oracle HINT directive into the Before page and into the SQL-User Defined page of stage:
[BEFORE PAGE] : ALTER SESSION ENABLE PARALLEL DML
[SQL-USER DEFINED] : INSERT /*+APPEND PARALLEL (BULK,5)*/ INTO ......
During the execution of job I monitored the sessions opened on Oracle server end I verify the only one session was opened.
What is the rigth way to use the PARALLEL DML feature of ORACLE 9.x?
Thanks a lot.
by[?]