Re: redo logs and IO please advise

Try v$filestat and v$waitstat.

"Kev.-" wrote:

> 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.-
Received on Thu Mar 29 2001 - 07:00:26 CST