transactional Lock type TX TM, UL (merged 2) [message #413691] |
Fri, 17 July 2009 01:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
casttree
Messages: 83 Registered: August 2008
|
Member |
|
|
I am trying to understand more for transactional lock type TM, TX, and UL.
Looks like if I lock one table in exclusive mode, (like lock table emp in exclusive mode" in two sessions , we can get TM lock. Can we get the lock type TX and UL easily?
Thanks,
|
|
|
|
Re: transactional Lock type TX TM, UL (merged 2) [message #413853 is a reply to message #413691] |
Fri, 17 July 2009 17:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
casttree
Messages: 83 Registered: August 2008
|
Member |
|
|
Thanks, how about the lock type in RAC?
If I login Rac Inst 1 as scott and "lock table EMP in exclusive mode" and then login RAC Inst2 and "lock table EMP in exclusive mode" , they should issue the block session?
also one more question for SQ lock, any examples for SQ lock?
Thanks,
|
|
|
Re: transactional Lock type TX TM, UL (merged 2) [message #413885 is a reply to message #413853] |
Sat, 18 July 2009 01:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | how about the lock type in RAC?
|
No change. Locks are holding marks on database objects, it does not matter you have one or many instances.
Quote: | how about the lock type in RAC?
|
You get a SQ lock when you ask for a sequence number and Oracle has to generate new numbers in cache and update sys.seq$.
Regards
Michel
|
|
|