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: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 15 Nov 2005 14:59:03 GMT
Message-Id: <pan.2005.11.15.14.59.01.394306@sbcglobal.net>


On Tue, 15 Nov 2005 01:38:09 -0800, InjacHardy wrote:

> OK, let have an example: there is a frequent log switching in a
> database. A session is generating an excessive amount of redo. I can
> easily find which session it is by looking into v$sesstat and "redo
> size" statistics.
>
> But, I would like to be able to see for each SQL statement that session
> is running the amount of redo entries (in bytes) it generates. Even
> approximate amount would be fine.
> For example:
> SQL STATEMENT REDO SIZE
> ----------------------- ------------
> UPDATE ACC SET A=3; 8460 bytes
> SELECT .A FROM DUAL; 0 bytes
> DELETE NOM; 469000 bytes
> ... etc
>
> Regards,
> Tanya

The place to look for that, if that existed, would be V$SQL. I am not sure what would be the use of such statistics?

-- 
http://www.mgogala.com
Received on Tue Nov 15 2005 - 08:59:03 CST

Original text of this message

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