Re: Question about REDO logs.

From: Andreas Rath <A.Rath_at_DeutschePost.De>
Date: Wed, 21 Mar 2001 12:23:30 +0100
Message-ID: <99a2pp$86q4@ppd00021.deutschepost.de>

Hi Kev.-,
you will find informations about Redo-Logs in the tables:

v$logfile
v$log

Andreas

"Kev.-" <java2e_at_yahoo.com> schrieb im Newsbeitrag news:3ab80122.20340387_at_news.zyan.com...
> 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.-
>
Received on Wed Mar 21 2001 - 05:23:30 CST