OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » lockwait

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

lockwait [message #307840]

Thu, 20 March 2008 02:29

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

Report message to a moderator

Re: lockwait [message #307841 is a reply to message #307840]

Thu, 20 March 2008 02:35

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

When session is waiting for a lock.

Regards
Michel

Report message to a moderator

Re: lockwait [message #307866 is a reply to message #307840]

Thu, 20 March 2008 03:48

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)

Report message to a moderator

Previous Topic:	Can anybody explain this index
Next Topic:	How can we write this query in a better or more efficeint way?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 15:13:30 CST 2025