Re: locked session

From: Mark D Powell <mark.powell_at_eds.com>
Date: 15 Aug 2002 13:15:14 -0700
Message-ID: <178d2795.0208151215.1554867d@posting.google.com>

"OlgaS" <olgas_at_port.imtp.ilyichevsk.odessa.ua> wrote in message news:<ajg7il$c9g$1_at_News.TM.Odessa.UA>...
> 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

Try looking at the cooperative FAQ. There are a couple of articles under DBA on locking and related issues like seeing what rbs segments are being used by a session etc....

http://www.jlcomp.demon.co.uk/faq/ind_faq.html

HTH -- Mark D Powell -- Received on Thu Aug 15 2002 - 15:15:14 CDT