Sessions in the lock list with no locks (0,0) 
Author Message
 Sessions in the lock list with no locks (0,0)

Hi,

This is Tom Turchioe.  Locklists with zero locks are probably session
lock lists which hold all locks associated with a session.  If they are
system locklists, they won't go away until the server holding them shuts
down.  Unless the Status is "WAIT", don't worry about it.

Tom

--
Posted via http://www.***.com/



Mon, 30 May 2005 16:17:27 GMT
 Sessions in the lock list with no locks (0,0)

Quote:
>-----Original Message-----

>Sent: 12 December 2002 12:47

>Subject: Re: Sessions in the lock list with no locks (0,0)

>Nice to hear from you.

Ditto.

I suspect that most readers of this group are unaware of Tom's valuable
contributions to Ingres over the years.

************************************************************************
DISCLAIMER

The information contained in this e-mail is confidential and is intended
for the recipient only.

If you have received it in error, please notify us immediately by reply
e-mail and then delete it from your system. Please do not copy it or
use it for any other purposes, or disclose the content of the e-mail
to any other person or store or copy the information in any medium.

The views contained in this e-mail are those of the author and not
necessarily those of GEHE Group companies.
************************************************************************



Mon, 30 May 2005 21:16:41 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Sessions in the lock list with no locks (0,0)

2. SQL7 session hangs, bogus index lock?

3. Record locked by current session

4. Sessions, threads, locks in isapi

5. Record locking from a EJB session bean

6. sessions and locks on procedures

7. Kill session and ORACLE does not free locks...

8. dead(locked?) sessions

9. Locking: Matching up sessions

10. Killed Session locks table, but has no process (spid)

11. ORACLE LOCKED SESSION HELP

12. How do kill a locked session


 
Powered by phpBB® Forum Software