Re: redo logs and IO please advise

There is no such thing.
It is redundant also, as every write to a database file is preceded by a similar write to a redo log files, and redo log files are never read, except on instance recovery.
You could derive a few things from v$loghistory, a start and end times are included, and the size of a redo log file is fixed.

Hth,

Sybrand Bakker, Oracle DBA

"Kev.-" <java2e_at_yahoo.com> wrote in message news:3ac2a0cd.329368987_at_ns1.nothingbutnet.net...
> 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 Wed Mar 28 2001 - 22:56:22 CST