Home » RDBMS Server » Server Administration » Use of LM( Lock mode) in V$lock (10.2.3.0 standard edition,Microsoft Windows server 2003)
Use of LM( Lock mode) in V$lock [message #567654] Thu, 04 October 2012 01:11 Go to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Dear All,

Good day,

Today i need to know some thing in v$lock,we know we can see lock mode held in session can be analysed using LM column in v$lock.But i confused in seeing LM column it all shows in numbers from 0 to 6.
eg
0,'None(0)',
1,'Null(1)',
2,'Row Share(2)',
3,'Row Exclu(3)',
4,'Share(4)',
5,'Share Row Ex(5)',
6,'Exclusive(6)')

Can any one clarify difference of all 6 lock mode breifly, please answer me.

Thanks&Regards,
Anil
Re: Use of LM( Lock mode) in V$lock [message #567655 is a reply to message #567654] Thu, 04 October 2012 01:14 Go to previous message
Michel Cadot
Messages: 57616
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts
Chapter 13, "Data Concurrency and Consistency"

Regards
Michel
Previous Topic: Not able to logins as ssysdba
Next Topic: TNS:listener does not currently know of service
Goto Forum:
  


Current Time: Mon Apr 21 06:27:52 CDT 2014

Total time taken to generate the page: 0.11424 seconds