I'm running a JAL script that reads in a loop an INI file. After getting the table name I check if the ORACLE table exists, and import through SQLLOADER using the RunAndWait statement. I have to feed 36 tables. Oftern the script hangs my machine, probably due to memory problems.

Any suggestions ??

Robbert de GROOT

Because you are running it as a script you can add MemoryGetFree statement after each load and append the result of MemoryGetFree to some file. This way you can check whether you have a memory leak and if yes how big it is.
If there is memory leak try splitting the job on the main loop and the load job. Set the load job to run as "detached". This way you can recover the lost memory.

: I'm running a JAL script that reads in a loop an INI file. After getting the
: table name I check if the ORACLE table exists, and import through
: SQLLOADER using the RunAndWait statement. I have to feed 36 tables. Oftern
: the script hangs my machine, probably due to memory problems.

: Any suggestions ??

: Robbert de GROOT