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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find amount of redo generated per a SQL statement?

Re: How to find amount of redo generated per a SQL statement?

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 17 Nov 2005 21:42:56 GMT
Message-ID: <437cf91d.105328906@localhost>

On 16 Nov 2005 20:09:54 -0800, "InjacHardy" <injac_at_yahoo.com> wrote:

>Thanks.Tom's idea is to capture statistics within the application. But,
>as I am a DBA and I can't change the application. I just need to react
>fast when there is a session that is production excessive amount of
>redo entries.

If you need to 'catch a session', why not just look at v$session_stats/v$session_events

-A
.......
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4 remove NSPAM to email Received on Thu Nov 17 2005 - 15:42:56 CST

Original text of this message

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