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