Re: Redo log io?

In article <3ac28215.321504769_at_ns1.nothingbutnet.net>, Kev.- <java2e_at_yahoo.com> writes:
>Hello All,
>
>Now that I know the right question to ask here it goes. What table
>can you query to get the IO (physical reads and writes) that they are
>producing?
>
>For example when I query v$filestat I am able to get reads and writes
>that the file has produced since the oracle server was booted as the
>values keep incrementing until re-booted/ shutdown-re-started, etc...
>
>How can I get these same values for the redo logs. I have looked the
>the v$log, v$logfile but there is nothing there.
>
>Thanks,
>
>Kev.-

Kev, the only statistics that come to mind for the online redo logs are in v$sysstat (where name like 'redo%'.

• 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