RE: Blocking and locking on 3-tier oracle app

Simon

   Just another idea for you, that may or may not be helpful. I haven't worked with Forms, others on this list can provide some ideas. However, I have seen some weird behavior from Micro$oft apps based on VB and ASP. If the database connection is left with mostly defaults, the app will tend to lock entire groups of rows and maybe even tables. You might do some tracing to find the exact SQL that is being inflicted on your database.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, September 26, 2003 6:40 AM To: Multiple recipients of list ORACLE-L

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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).