In article <3ab80138.20362429_at_news.zyan.com>, Kev.- <java2e_at_yahoo.com>
writes:
>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.-
>
Kev, try looking at v$sysstat for name like 'redo%'. Also v$latch for the
redo copy latches.
- Mark D. Powell --
- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
NewsOne.Net prohibits users from posting spam. If this or other posts
made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net
Received on Fri Mar 23 2001 - 09:07:50 CST
