Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find amount of redo generated per a SQL statement?
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.
The statistic I need is obviously available within Oracle, just Oracle itself does not clasify it per SQL statement, just per a session. Maybe they will in the future.
Regards,
Tanya
Received on Wed Nov 16 2005 - 22:09:54 CST