V$FILEMETRIC

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

V$FILEMETRIC displays values of file metrics for the most recent 10-minute interval. A history of the last one hour will be kept in the system.

Column	Datatype	Description
BEGIN_TIME	DATE	Begin time of the interval
END_TIME	DATE	End time of the interval
INTSIZE_CSEC	NUMBER	Interval size (in hundredths of a second)
FILE_ID	NUMBER	File number
CREATION_TIME	NUMBER	Timestamp of the file creation
AVERAGE_READ_TIME	NUMBER	Average file read time
AVERAGE_WRITE_TIME	NUMBER	Average file write time
PHYSICAL_READS	NUMBER	Number of physical reads
PHYSICAL_WRITES	NUMBER	Number of physical writes
PHYSICAL_BLOCK_READS	NUMBER	Number of physical block reads
PHYSICAL_BLOCK_WRITES	NUMBER	Number of physical block writes

Note:

1.       In Oracle10g metrics are automatically calculated based on basic statistics to track the rates of changes in the activity of the Database. Most of the metrics are calculated every 60 seconds. The following is a list of views to access metrics information:

·         V$SYSMETRIC

·         V$SESSMETRIC

·         V$FILEMETRIC

·         V$EVENTMETRIC

·         V$WAITCLASSMETRIC

·         V$METRICNAME

Oracle data dictionary views

Oracle dynamic performance views

Last updated: 2009-12-22 Tuesday