| transactional Lock type TX TM, UL (merged 2) [message #413691] |
Fri, 17 July 2009 01:40  |
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  |
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 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
