Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 201 of 211


V$TEMPSTAT

This view contains information about file read/write statistics.

Column  Datatype  Description 

FILE# 

NUMBER 

Number of the file 

PHYRDS 

NUMBER 

Number of physical reads done 

PHYWRTS 

NUMBER 

Number of times DBWR is required to write 

PHYBLKRD 

NUMBER 

Number of physical blocks read 

PHYBLKWRT 

NUMBER 

Number of blocks written to disk; may be the same as PHYWRTS if all writes are single blocks 

READTIM  

NUMBER 

Time (in hundredths of a second) spent doing reads if the TIMED_STATISTICS parameter is TRUE; 0 if FALSE 

WRITETIM 

NUMBER 

Time (in hundredths of a second) spent doing writes if the TIMED_STATISTICS parameter is TRUE; 0 if FALSE 

AVGIOTIM 

NUMBER 

The average time (in hundredths of a second) spent on I/O, if the TIMED_STATISTICS parameter is TRUE; 0 if FALSE 

LSTIOTIM 

NUMBER 

The time (in hundredths of a second) spent doing the last I/O, if the TIMED_STATISTICS parameter is TRUE; 0 if FALSE 

MINIOTIM 

NUMBER 

The minimum time (in hundredths of a second) spent on a single I/O, if the TIMED_STATISTICS parameter is TRUE; 0 if FALSE 

MAXIOWTM 

NUMBER 

The maximum time (in hundredths of a second) spent doing a single write, if the TIMED_STATISTICS parameter is TRUE; 0 if FALSE 

MAXIORTM 

NUMBER 

The maximum time (in hundredths of a second) spent doing a single read, if the TIMED_STATISTICS parameter is TRUE; 0 if FALSE 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback