Re: File IO on Redo logs

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 26 Apr 1999 20:11:09 +0100
Message-ID: <925154455.16491.0.nnrp-06.9e984b29@news.demon.co.uk>

Your best bet is to pick 5 or 6 rows from the v$sysstat table - e.g.

redo blocks written
redo writes

etc

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

g.renfrew_at_acca.org.uk wrote in message <7g1qgj$b9i$1_at_nnrp1.dejanews.com>...
>Hi,
>
>I am trying to generate IO stats for the files in a 7.3.2.3 database. I
can
>pretty easily get stats for the datafiles via the v$filestat view.
However,
>how can I do the same for the redo log files? Is it possible?
>
>Many thanks
>
>Graeme Renfrew
>Junior DBA
>ACCA
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Apr 26 1999 - 14:11:09 CDT