Re: Really stuck and cant find an answer help.

Thanks at least now I have a starting point. I hope this information is in here looks like some more searching.

Thanks again,

Kev.-

On Tue, 20 Mar 2001 22:33:23 -0500, "Braxton Robbason" <robbason_at_hotmail.com> wrote:

>I was looking at SQLPLUS command tracing, which shows statistics, and I
>think you might want to look at the oracle documentation for stuff relating
>to
>set autotrace on
>in sqlplus. Specifically,
>
>select a.sid, b.statistic#, b.class, a.value,substr(b.name,1,30)
>from v$sesstat a,
> v$statname b
>where a.statistic#=b.statistic#
>
>will show you the statistics for a lot of things, including the redo logs.
>There is a description of all these statistics in the docs, it's linked from
>the V$SESSTAT view information under reference.
>
>hope this helps a bit.
>
>"Kev.-" <java2e_at_yahoo.com> wrote in message
>news:3ab7de9c.11502519_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 Tue Mar 20 2001 - 22:19:46 CST