|
Home > Archive > Oracle Server > May 2005 > Help: Is there any way we can find how many times a session has committed?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Help: Is there any way we can find how many times a session has committed?
|
|
| charlie cs 2005-05-28, 8:23 pm |
| 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.
| |
| IANAL_VISTA 2005-05-28, 8:23 pm |
| "charlie cs" <cfs3526(no-spam)@ureach.com> wrote in
news: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?
>
Go visit http://asktom.oracle.com & do some research
or buy Tom's book
Expert One-on-One Oracle
# ISBN: 1590592433
| |
| charlie cs 2005-05-28, 8:23 pm |
| > 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?
| |
| IANAL_VISTA 2005-05-29, 3:23 am |
| "charlie cs" <cfs3526(no-spam)@ureach.com> wrote in
news:WS8me.2439$615.1810@trnddc08:
> We are using Oracle 9i
>
> We are using UNDO tablespace
>
> 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?
>
> 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.
|
|
|
|
|