[Logo] Terracotta Discussion Forums (LEGACY READ-ONLY ARCHIVE)
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
[Expert]
Quartz cluster + Oracle RAC - locking  XML
Forum Index -> Quartz
Author Message
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
 
Forum Index -> Quartz
Go to:   
Powered by JForum 2.1.7 © JForum Team