select c.SID,c.SERIAL#,c.terminal,c.PROGRAM,c.type,c.SQL_ID,d.SQL_TEXT,b.NAME,a.value from v$session c,v$sesstat a,v$statname b,v$sql d
where b.STATISTIC#=a.STATISTIC#
and b.NAME='redo size'
and c.SID=a.SID
and d.SQL_ID(+)=c.sql_id;
查询示例:
and d.SQL_ID(+)=c.sql_id;
查询示例: