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

charlie cs wrote:
> 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.

Lets see how little useful information can be provided? Oracle version number?
Using rollback or UNDO?
SQL or PL/SQL?
Executing what DML statements?
In a loop?

If I had my ouija board nearby I could accurately diagnose your problem but rather than just blindly guess ... you provide something from which a reasonable response might be derived. We will both be a lot happier.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)