Re: Question about REDO logs.

Kev.- wrote:
>
> Hello,
>
> I am not sure if this can even be done but I was asked to get the IO
> stats from the REDO logs. I have no clue what V$ table I need to go
> to to get this information if it is even indeed possible. Could some
> please advise me on this as I have been scanning the web for hours and
> found nothing.
>
> I think what they what is to get performance information to see where
> the problems are occuring. I noticed that you can get Latch
> Statistics for REDO logs but what about IOs. Also what table can I
> goto to get the names of all the REDO log files.
>
> Thanks,
>
> Kev.-

Check out v$sysstat for redo writes

Also look at v$logfile and v$log.

hth
connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"