Re: Question about REDO logs.

Thanks!

Kev.-

On Wed, 21 Mar 2001 22:03:17 +0800, Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:

>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"
Received on Wed Mar 21 2001 - 17:14:50 CST