Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: locked session
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