SQL Script Find Redo

Updated: 28-Dec-2005
Version: 1.0

Description

Script to see what session are using redo

Parameters

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

SELECT s.sid, s.serial#, s.username, s.program,
  i.block_changes
 FROM v$session s, v$sess_io i
  WHERE s.sid = i.sid
 ORDER BY 5 desc, 1, 2, 3, 4;

SELECT s.sid, s.serial#, s.username, s.program, 
   t.used_ublk, t.used_urec
   FROM v$session s, v$transaction t
   WHERE s.taddr = t.addr
   ORDER BY 5 desc, 6 desc, 1, 2, 3, 4;

select s.sid, sn.name, s.value, sess.program
from v$sesstat s, v$statname sn, v$session sess
where s.sid=sess.sid
and sn.statistic#=s.statistic#
and sn.name like 'redo size'
and s.value != 0
order by s.value, s.sid, sn.name
/                      

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links