Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Performance of Java in invoking Shell Scripts and SQL*Loader

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I have a java code which invokes a shell script using the Runtime Object. This script in turn invokes a sqlldr to load data from a flat file to a database. The java code waits for the loader to complete the loading using the process.waitFor() method, and then does some more logic.

The performance of this process is very poor. The sqlldr loads about 11600 records from a file containing 34, 000 records and then hangs. No more record is loaded. But, the sqlldr is active as a process and the java code waits for completion of the loader indefinitely.

Kindly let me know the solution for this problem.

Thanks.
Arthi.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top