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
http://web.singnet.com.sg/~hkchital
--
//www.freelists.org/webpage/oracle-l
Other related posts:
