Re: Blocking and locking on 3-tier oracle app

Hi!

1. You can set idle_time profile option in server, to automatically disconnect sessions idle for some time.
2. You can set sqlnet.expire_time to some minutes or hours, that Oracle would probe all sessions over some interval and disconnect the ones which don't have a corresponding client anymore
3. You'r app should commit at the end of transactions, it should not lock too many rows just in case, if possible.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, September 26, 2003 2:39 PM

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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