Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question about REDO logs.
Hello Andreas,
Thank you!
Kev.-
On Wed, 21 Mar 2001 12:23:30 +0100, "Andreas Rath" <A.Rath_at_DeutschePost.De> wrote:
>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 - 17:20:39 CST
![]() |
![]() |