[Home] [Help] [Dependency Information]
Object Name: | GV_$FILEMETRIC |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
BEGIN_TIME | DATE | |||
END_TIME | DATE | |||
INTSIZE_CSEC | NUMBER | |||
FILE_ID | NUMBER | |||
CREATION_TIME | NUMBER | |||
AVERAGE_READ_TIME | NUMBER | |||
AVERAGE_WRITE_TIME | NUMBER | |||
PHYSICAL_READS | NUMBER | |||
PHYSICAL_WRITES | NUMBER | |||
PHYSICAL_BLOCK_READS | NUMBER | |||
PHYSICAL_BLOCK_WRITES | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, BEGIN_TIME
, END_TIME
, INTSIZE_CSEC
, FILE_ID
, CREATION_TIME
, AVERAGE_READ_TIME
, AVERAGE_WRITE_TIME
, PHYSICAL_READS
, PHYSICAL_WRITES
, PHYSICAL_BLOCK_READS
, PHYSICAL_BLOCK_WRITES
, CON_ID
FROM SYS.GV_$FILEMETRIC;
|
|
|