Page 1 of 1
Lock on file due to muliple instances
Posted: Tue Apr 17, 2007 8:13 am
by 47shailesh
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.
Posted: Tue Apr 17, 2007 8:20 am
by DSguru2B
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?
Posted: Tue Apr 17, 2007 8:42 am
by 47shailesh
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
Posted: Tue Apr 17, 2007 8:49 am
by DSguru2B
By parametrizing the names.
Posted: Tue Apr 17, 2007 9:01 am
by 47shailesh
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..
Posted: Tue Apr 17, 2007 9:03 am
by DSguru2B
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.