locked session

From: OlgaS <olgas_at_port.imtp.ilyichevsk.odessa.ua>
Date: Thu, 15 Aug 2002 15:36:08 +0300
Message-ID: <ajg7il$c9g$1@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 Received on Thu Aug 15 2002 - 07:36:08 CDT