Home » RDBMS Server » Performance Tuning » lockwait
lockwait [message #307840] Thu, 20 March 2008 02:29 Go to next message
sidd_411
Messages: 30
Registered: March 2008
Member
Hi,

When the lockwait column of v$session will be non-null? Can anyone explain me from db user point of view rather than dba view
Re: lockwait [message #307841 is a reply to message #307840] Thu, 20 March 2008 02:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When session is waiting for a lock.

Regards
Michel
Re: lockwait [message #307866 is a reply to message #307840] Thu, 20 March 2008 03:48 Go to previous message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Hi,

When sessions are waiting for lock held by other session.
For Example, when same row in two diffenerent sessions are updated / deleted and not commited (lock is not released)
Previous Topic: Can anybody explain this index
Next Topic: How can we write this query in a better or more efficeint way?
Goto Forum:
  


Current Time: Wed Dec 07 06:35:33 CST 2016

Total time taken to generate the page: 0.09589 seconds