Re: Identifying SQLs causing the highest Redo
- From: Mark Bole <makbo@xxxxxxxxxxx>
- Date: Mon, 11 Apr 2005 09:03:52 -0700
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
