Re: Calculating Oracle database i/o per second

From: Ari Kaplan <akaplan_at_interaccess.com>
Date: Thu, 16 Dec 1999 01:22:30 -0600
Message-ID: <s5h4r5juqrs181@corp.supernews.com>

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.

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 345+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             http://homepage.interaccess.com/~akaplan          <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

ngreene_at_my-deja.com wrote in message <838uvu$j86$1_at_nnrp1.deja.com>...
>I was wondering if anyone has a solution for calculating a database i/o
>(reads/writes) per second, or per minute. I would like to plot this
>over time and I am wondering how to get this data.
>
>I know v$filestat has statistics for phyreads/phywrites, but I need
>some concept of a timer.
>
>--
>Neil Greene
>Earthlink Network
>email: ngreene_at_my-dejanews.com
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Dec 16 1999 - 01:22:30 CST