Blocking and locking on 3-tier oracle app

From: Simon Gregory <simon.gregory_at_gateshead.ac.uk>
Date: Fri, 26 Sep 2003 03:39:41 -0800
Message-ID: <F001.005D12DE.20030926033941@fatcity.com>

Hi,

Apologies if this has been asked before, or is a really lame question.

We currently have lots of locking problems running a web-deployed (J-initiator on Win2k) off-the-shelf application. The application is running from an Oracle Forms 6i patch 12 application server on Windows 2000 sp4 and an Oracle 9iR2 database on Solaris9.

The problems seem primarily to be caused by "dead" sessions hanging around on the database server and holding locks on records.

Is there anything that can be done about this? Is there a timeout parameter (or something) that can be set?

The locks only clear when I manually identify the bad sessions through enterprise manager and kill them off.

Thanks,

Simon.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Simon Gregory
  INET: simon.gregory_at_gateshead.ac.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Sep 26 2003 - 06:39:41 CDT