Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help: Is there any way we can find how many times a session has committed?

Help: Is there any way we can find how many times a session has committed?

From: charlie cs <cfs3526(no-spam)_at_ureach.com>
Date: Sat, 28 May 2005 22:12:54 GMT
Message-ID: <G16me.14791$GN3.732@trnddc04>


I believe one of our application has set conn.AutoCommit=true, and the session commit too often, because I often got 01555 errors when running long query.

Is there any way I can tell which session commit too often and get some hard evidence from dynamic view before I go to talk to any developer?

Thanks very much for your help. Received on Sat May 28 2005 - 17:12:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US