Re: Really stuck and cant find an answer help.

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 - 21:33:23 CST