pradheep
neo
Joined: 08/05/2014 23:56:05
Messages: 1
Offline
|
Hi
We are observing too many row lock contention issues with Oracle (RAC).
Just want to know what will be the impact or behavior if we change the locking query in Quartz.
org.quartz.jobStore.selectWithLockSQL [b]"SELECT * FROM {0}LOCKS WHERE LOCK_NAME = ? FOR UPDATE"[/b]
can we use
"SELECT * FROM {0}LOCKS WHERE LOCK_NAME = ? FOR UPDATE NOWAIT"
Is there any other feasible way of avoiding too many row lock contention in Oracle RAC. We are observing quite large number of locks on Quartz Lock tables.
Thanks,
Pradheep
|