Re: Rollback Question

From: salu Ullah <salu_ullah_at_hotmail.com>
Date: Tue, 06 Feb 2001 11:12:28 -0800
Message-ID: <F001.002AC2BF.20010206082618@fatcity.com>

Hello Casey

Run this script. It will display rollback & commit of all running session

set head     on
set echo     off

set verify off
set feedback off
set pagesize 1000

set tab      off
col "SID"               format 999
col "Nb commit"        format 99,999,999,999
col "Nb rollback"      format 999,999,999

-- to find the
select  min(sid)         "SID",
        sum(cmt)  "Nb commit",
        sum(roll) "Nb rollback"
        from (
              select ses.sid, st.value cmt, 0 roll
              from v$session ses, v$sesstat st, v$statname nm
              where ses.sid = st.sid and
                    st.statistic# = nm.statistic# and
                    nm.NAME = 'user commits'
            union
              select ses.sid, 0, st.value
              from v$session ses, v$sesstat st, v$statname nm
              where ses.sid = st.sid and
                    st.statistic# = nm.statistic# and
                    nm.NAME = 'user rollbacks'
              )

group by sid ;

>From: "Casey Jordan" <cjordan_at_smcwv.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Rollback Question
>Date: Tue, 06 Feb 2001 06:00:23 -0800
>
>Is there anyway to find out if a long running concurrent program is rolling
>back its transactions?
>
>
>Thanks
>
>Casey

---

Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: salu Ullah
  INET: salu_ullah_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Feb 06 2001 - 13:12:28 CST