Re: redo logs and IO please advise

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 Wed Mar 28 2001 - 23:42:32 CST