Re: redo logs and IO please advise

Thank you for the information. I will try to explain this to the client and hopefully then will stop pushing for these results.

On Thu, 29 Mar 2001 06:56:22 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>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 Mon Apr 02 2001 - 17:44:05 CDT