Lock on file due to muliple instances

47shailesh · Post by **47shailesh** » Tue Apr 17, 2007 8:13 am

My job for inserts using OraBulk stage ran smoothly without any error

But when i created multiple instances(3) of the same job and ran the job, my job's 2 instances aborted one due to lock on SP.ctl file and other due to lock on SP.txt file..

is there a way to run the job with multiple instance without any lock.. My basic moto is to reduce the runtime of the job.

DSguru2B · Post by **DSguru2B** » Tue Apr 17, 2007 8:20 am

How many records are we looking at? Cant a single instance take care of the load? Use different names for different instances for the control file. Is SP.txt the data file?

47shailesh · Post by **47shailesh** » Tue Apr 17, 2007 8:42 am

DSguru2B wrote:How many records are we looking at? Cant a single instance take care of the load? Use different names for different instances for the control file. Is SP.txt the data file?

final load will load 2billion records...

How to use different names for different instances for the control file

yes SP.txt is data file

DSguru2B · Post by **DSguru2B** » Tue Apr 17, 2007 8:49 am

By parametrizing the names.

47shailesh · Post by **47shailesh** » Tue Apr 17, 2007 9:01 am

DSguru2B wrote:By parametrizing the names.

ok that will generate 3 diff ctl file..
what about the data file

how these ctl file can be used to load table in lesser time..

DSguru2B · Post by **DSguru2B** » Tue Apr 17, 2007 9:03 am

Well If you are using three different instances for loading data then I bet you will be using three different chunks of the entire data. You cannot load the same data file with all the instances. You will, just like the .ctl files, use three different .dat files, which will be parametrized as well.