RE: Rollback Question
Hi Casey, Look at the USED_UBLK field in V$TRANSACTION, twice. If the number is going down, then the transaction is rolling back. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Wednesday, 7 February 2001 0:00 To: Multiple recipients of list ORACLE-L Is there anyway to find out if a long running concurrent program is rolling back its transactions? Thanks Casey -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Rollback Question
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" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Rollback Question
The following script will be helpful as per Steve Adams suggestion...If no of transcations going down it means there is rollback of process... set linesize 120 select substr(a.os_user_name,1,8) "OS User" , substr(b.object_name,1,30) "Object Name" , substr(b.object_type,1,8) "Type" , substr(c.segment_name,1,10) "RBS" , e.process "PROCESS" , substr(d.used_urec,1,8) "# of Records" from v$locked_object a , dba_objects b , dba_rollback_segs c , v$transaction d , v$session e where a.object_id = b.object_id and a.xidusn = c.segment_id and a.xidusn = d.xidusn and a.xidslot = d.xidslot and d.addr = e.taddr / Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 06 Feb 2001 08:40:22 -0800 Hi Casey, Look at the USED_UBLK field in V$TRANSACTION, twice. If the number is going down, then the transaction is rolling back. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Wednesday, 7 February 2001 0:00 To: Multiple recipients of list ORACLE-L Is there anyway to find out if a long running concurrent program is rolling back its transactions? Thanks Casey -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).