Re: does oracle use block level locking with RAC?

> I saw on a board somewhere that someone is having deadlock issues due to
> block level locking with Oracle RAC? I thought Oracle always did row level
> locking on everything? Could this be a mis-perception with something else?

Rick, I think you're concerned about transaction locks which are only at row
level. If you're concerned about the locks that may cause deadlocks, whether
they're simple transaction deadlocks (ORA-60) or others (e.g. ORA-4020,
ORA-12829), there's an old document "Description of Oracle7 Wait Events and
Enqueues" that describes most of the locks with a yes or no answer for
"Deadlock Sensitive". Part of the document is in Note:75705.1. But both were
written before many Oracle features were added.

I think buffer locks used to have an enqueue for it, BL. It's not deadlock
sensitive. Now you can't even find it in v$lock_type. The concept of block
level locking is sometimes brought up in literature about Oracle8i OPS, or XA
transactions. I've never heard of a deadlock situation due to RAC buffer
locking, or XA transactions.

Yong Huang


      
____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
--
http://www.freelists.org/webpage/oracle-l


Other related posts: