Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Mon Apr 11 2005 - 11:12:37 CDT
![]() |
![]() |