Re: Microsoft Txn Server / Locking issues

Check out if the program do updates and commit all in one enter. If the program updates some central table and then ask the user to commit or rollback and he is out for a smoke then the rows will stay locked until he returns.

Here we stress the importance of doing update+commit at once without user input between them.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, August 01, 2002 12:41 AM

> Anybody have any experience with Microsoft Txn Server? I am running into
> issues with a few Windows2000 servers running Microsoft Txn Servers that
are
> connecting to my 8.1.7.4 HP-UX database. There are several concurrent
txns
> running that do a lot of inserting and data loading. Most of the time it
> runs okay, but 3 or 4 times a day, I get several txns stuck waiting on
> enqueues. I can easily see what session is holding up all the others, and
> it always is an apparent idle session (wait event = SQL*Net waiting from
> client"), that is coming from one of these windows2000 servers. Once I
kill
> that session, all the other enqueues go away. I have taken systemstate
> dumps and have been working with Oracle Support, but they are starting to
> say that it is an App issue - and it may be, but I just can't see how an
> idle session can be causing 30+ sessions to wait for it. And most times,
> the last statement run in this idle session is a SELECT.
>
> I have also increased my initrans for the tables and indexes and made sure
> the FKs are indexed.
>
> Any ideas?
>
> TIA
>
>
>
>
> John Fedock
> "K" Line America, Inc.
> www.kline.com
> * john.fedock_at_kline.com
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Fedock, John (KAM.RHQ)
> INET: John.Fedock_at_KLINE.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).