RE: Blocking and locking on 3-tier oracle app

Simon,

   Look for CREATE PROFILE in the SQL Reference for setting a limit on idle times.

SF

>----- ------- Original Message ------- -----
>From: "Simon Gregory"
><simon.gregory_at_gateshead.ac.uk>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Fri, 26 Sep 2003 03:39:41
>
>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: Stephane Faroult
  INET: sfaroult_at_oriolecorp.com

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).