Re: Calculating Oracle database i/o per second

V$SYSSTAT holds cumulated counters for

    physical reads
    physical writes

Cheers -- Fred

Neil Greene wrote:

> In article <s5h4r5juqrs181_at_corp.supernews.com>, akaplan_at_interaccess.com
> says...
> > In INIT.ORA, set TIMED_STATISTICS=TRUE. Then restart the database instance.
> >
> > Then you can run "$ORACLE_HOME/rdbms/admin/utlbstat.sql" to start gathering
> > statistics. When you are
> > ready to see the file reads/writes, run
> > "$ORACLE_HOME/rdbms/admin/utlestat.sql". You will also find dozens of
> > usefull pieces of information about your database.
>
> Opps! I should have been more specific. I am looking for a way to
> collect this data at an interval, lets say every min, or every 3 min, and
> plot io/sec over the interval. In fact, I am looking for a way to plot
> the "Physical I/O" graph like that found in Quest Instance Monitor.
>
> --- Neil

--

+-------------------------------------+----------------------------+
| Fred Petillot                       |     fpetillo_at_fr.oracle.com |
| Oracle France - Support Technique   |            +33 1 4762 8201 |
| 65, rue des Trois Fontanot          |            +33 6 8089 5135 |
| 92732 Nanterre Cedex                |                            |
+-------------------------------------+----------------------------+