Thank you for visiting Spatial DBA - Oracle and ArcSDE.
I have stopped updating the blog.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
===============================================================
V$FILEMETRIC_HISTORY displays values of file metrics for all intervals in the last one hour.
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 |
Oracle data dictionary views
Last updated: 2009-12-22 Tuesday |
No comments:
Post a Comment