Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Identifying SQLs causing the highest Redo

Identifying SQLs causing the highest Redo

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Mon, 11 Apr 2005 23:08:31 +0800
Message-Id: <6.2.0.14.0.20050411230414.01ccea48@pop.singnet.com.sg>

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
Received on Mon Apr 11 2005 - 11:12:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US