Simon, Look for CREATE PROFILE in the SQL Reference for setting a limit on idle times.
SF >----- ------- Original Message ------- ----- >From: "Simon Gregory" ><[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >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: [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).
