Re: How to show biggest redo producers

On Fri, 01 Mar 2002 08:39:23 -0500, Tom wrote:

> I have a database producing tremendous amounts of redo, and I'd like to
> show which tables' updates are the biggest offenders. Is there a way to
> get these statistics? Will log miner work? Is it the only way?
>
> Tom

Here's a query that will give you SID which is esponsible for the most of redo generation. You can then drill deeper by using v$sqlarea which contains columns like 'DISK_READS' and 'BUFFER_GETS'. It should be rather easy guess once you determine which SID is the worst offender. The other method would be to use profiles and put a limit of 1000 logical reads per call. The offenders would be the people that are screaming.

-- 
Mladen Gogala