Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: locked session

Re: locked session

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 15 Aug 2002 20:55:22 +0100
Message-ID: <3D5C072A.2E7A@yahoo.com>


OlgaS wrote:
>
> Hi! At us a problem. I work with Oracle 8.05. The users more than 300 .
> Very often arise blocking, session hang at manipulation of the users to
> the same schema. I should them simply kill. But I can not understand,
> why it occurs.
> Can to someone it was possible to write inquiry, which allows to fix these
> locked session also would write down time, during which session
> Is locked? I shall be grateful, if someone will inform by the experience

Look at v$lock. There are 'held' (who has got the lock) and 'requested' (who wants it) columns. There is also a time for how long someone has had or has been waiting for the lock.

Use the sid column to link it back to v$session

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Thu Aug 15 2002 - 14:55:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US