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.
Lock on file due to muliple instances
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 60
- Joined: Tue Aug 29, 2006 11:14 pm
-
- Participant
- Posts: 60
- Joined: Tue Aug 29, 2006 11:14 pm
final load will load 2billion records...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?
How to use different names for different instances for the control file
yes SP.txt is data file
-
- Participant
- Posts: 60
- Joined: Tue Aug 29, 2006 11:14 pm
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.