set lines 120 pages 40
SELECT
   ses.sid "CURRENT SID",
   stat.name,
   ses.VALUE 
FROM
   v$sesstat ses,
   v$statname stat 
WHERE
   stat.statistic#= ses.statistic# 
   AND ses.sid = 
   (
      SELECT  sid 
      FROM    v$mystat 
      WHERE   rownum < 2 
   )
   --and ses.statistic# in (132, 133, 215)
   AND 
   (
      LOWER(stat.name) LIKE '%redo%' 
      OR LOWER(stat.name) LIKE '%undo%' 
   )
   AND ses.VALUE > 0
/