Oracle Row Locking
Posted: Wed Nov 07, 2007 10:22 am
Configuration: 2 nodes
Datastage Job Oracle EE Source stage ====> Oracle EE Target
Row count : 100000
During the run, the Oracle job hung. After investigating the hung job with the Oracle DBA, it was found that row locking was the problem. For some reason, Node 1 blocked Node 2 from inserting to the database.
Has anyone encountered this?
I thought the purpose of parallelism was to take advantage of dual processing. From what I can see, it's causing a problem.
Can anyone provide some insight on this.
Thanks
Datastage Job Oracle EE Source stage ====> Oracle EE Target
Row count : 100000
During the run, the Oracle job hung. After investigating the hung job with the Oracle DBA, it was found that row locking was the problem. For some reason, Node 1 blocked Node 2 from inserting to the database.
Has anyone encountered this?
I thought the purpose of parallelism was to take advantage of dual processing. From what I can see, it's causing a problem.
Can anyone provide some insight on this.
Thanks