Re: Identifying SQLs causing the highest Redo

Hemant K Chitale wrote:

> 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
>

Use Log Miner to examine your archived redo logs.

-Mark Bole

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