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

> Daniel A. Morgan wrote;
> Oracle version number?

We are using Oracle 9i

> Using rollback or UNDO?

We are using UNDO tablespace

> SQL or PL/SQL?

I am not sure which session is the offending session, which is doing the commit. Actually my question is, can we get a counting of commit group by sid?

> Executing what DML statements?In a loop?
of course it is inserting, but I am not sure which session is the quilty one, there are so many connections. Some of them in loop, some of them using static sql,
all I want to know is

" who is doing the insert one row, commit once, not insert several thousand rows and commit"

How can I find out? Received on Sat May 28 2005 - 20:26:14 CDT