Identifying SQLs causing the highest Redo

How do you identify SQL statements that cause the highest Redo ?
I cannot use V$SESSSTAT and "redo size"  as these are sessions that are 
created and dropped very frequently.
However, the SQLs seem to be shared.

I am not sure that I can use V$SQLAREA    BUFFER_GETS or DISK_READS   or 
StatsPack  listings of
SQLs by Buffer Gets, Disk Reads or Executions.

I know I can set MONITORING on individual tables but that still won't help 
me identify the SQLs.



Hemant K Chitale
http://web.singnet.com.sg/~hkchital


--
http://www.freelists.org/webpage/oracle-l

Other related posts: