Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question about REDO logs.

Re: Question about REDO logs.

From: Kev.- <java2e_at_yahoo.com>
Date: Wed, 21 Mar 2001 23:20:39 GMT
Message-ID: <3ab9373c.4565094@news.zyan.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US