"charlie cs" <cfs3526(no-spam)@ureach.com> wrote in
news:WS8me.2439$615.1810_at_trnddc08:
>> 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?
>
>
>
LOGMINER will reveal the culprit.
Received on Sat May 28 2005 - 20:55:39 CDT
