Subject: (Easy) How to See DB Reads/Writes
ngreene@my-deja.com wrote:

>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@my-dejanews.com

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 useful
pieces of information about your database.

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 345+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             http://www.arikaplan.com                          <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page