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

Join v$sesstat to v$statname on statistic#, and check the statistic "user commits" for each session.

If the sessions are never alive when you check, you might risk dumping each session's statistics as it logs off. This can be done with a logoff trigger.

I've just posted a short note on my website show a possible implementation:

    http://www.jlcomp.demon.co.uk/evidence.html

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated April 5th 2005






"charlie cs" <cfs3526(no-spam)@ureach.com> wrote in message 
news:G16me.14791$GN3.732_at_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.

>