select "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 v$filemetric
SELECT "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 V$FILEMETRIC
|
|
|