What kind of benefits you are looking for? Performance benefits or concurrency? Optimistic/Pessimistic have their own advantages and disadvantages. I have used optimisticUpdates and found huge difference in performance as it holds locks for a very short period of time thus avoiding deadlocks/lock escalations/memory issues with database.
Sunglasses. AKA Coolness prosthetic. This tiny ad doesn't need shades: