What is normal overhead for option 2. and repercussion in case of Oracle Financials implementations.
Regards Rafiq
Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 26 Sep 2003 04:17:35 -0800
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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
_________________________________________________________________
Get McAfee virus scanning and cleaning of incoming attachments. Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).