Identifying SQLs causing the highest Redo

  • From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 11 Apr 2005 23:08:31 +0800

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


Other related posts: