Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> about read_time in the report.txt --File i/o statistics

about read_time in the report.txt --File i/o statistics

From: B, Ravindra <Ravindra.B_at_compaq.com>
Date: Fri, 16 Jun 2000 16:07:25 +0800
Message-Id: <10530.109519@fatcity.com>


Hi ,

i was analysing the reprot.txt file that was generated by running the utlbstat and utlestat scripts.

i was refering to the systemwide tuning using utlbstat and utlestat.the explaination for the tablespace
statistics for the READ_TIME tell that the total amount of time is in 1/100ths of a second it took to
read all the blocks from the datafile.I am not able to understand how to analyse this column.

Ex.my report has 3278 as anentry under this column.It is the total time to read all the blocks
from the datafile.but is it in seconds or miliseconds or is it 3278*1/100seconds?.i guess i should
divide this value by the 7016 which is under BLKS_READ.

Pls someone advice.

thanks and Regards, Received on Fri Jun 16 2000 - 03:07:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US