Oracle write hangs infinitely

lstsaur · Post by **lstsaur** » Thu Oct 09, 2008 12:12 am

Please try one more test to see whether you are able to import the table definitions using Oracle's Plug-in.

vasa_dxx · Post by **vasa_dxx** » Fri Oct 10, 2008 8:25 am

The job hangs only when I try to Load Oracle.
But i succeeds when i do an Upsert/insert.

I need to configure sqlloader????

ArndW · Post by **ArndW** » Fri Oct 10, 2008 9:30 am

Excellent job of narrowing down the problem. So now you actually can get a data file and the SQL script and could reproduce the problem outside of DataStage so I would suggest you involve the DBA so that he or she can monitor what happens when you run it.

vasa_dxx · Post by **vasa_dxx** » Mon Oct 13, 2008 2:38 am

Thanks ArndW.
I can't see your suggestions after third line.
I set APT_ORA_WRITE_FILES =' (DIRECT=TRUE, PARALLEL=FALSE) '
Inspired by the success of Oraupsert , I tried Upsert on a table using a sort Stage whose Output is 918553 records. Now the same Porblem of hang is reproduced.
Does DS use sqllloader when the records cross a certain limit?

srividya · Post by **srividya** » Mon Oct 13, 2008 11:41 am

DBA should be able to help you.

from tuning perspective ths might help you

Creating indexes on the table you are trying to load
Partitioning the table
increasing the intial table size

Thanks
Srividya

vasa_dxx · Post by **vasa_dxx** » Wed Oct 15, 2008 6:03 am

Thanks everybody for the Technical guidance.
The issue isn't resolved yet, but hope it soon due to diligence efforts by the members of this forum.

Although not complete resolution, but narrowing down the possibilty of cause gave me a good knowledge of the basics required.

Thanks Folks,