Re: redo logs and IO please advise

 I will look into the SAR program.

On Thu, 29 Mar 2001 00:42:32 -0500, "Ross Mohan" <skipdext at ix.netcom.com> wrote:

>There is an X$ table that you can pull it from.
>
>Just as well, really, to time your log switches, look
>at log events at system level, and do some os-level
>sar work to acheive the result you want.
>
>
>"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
>news:tc5gpalnlqduda_at_beta-news.demon.nl...
>> 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:39 CDT