GV$FILEMETRIC_HISTORY
SELECT inst_id, -- INST_ID NUMBER begtime, -- BEGIN_TIME DATE endtime, -- END_TIME DATE intsize_csec, -- INTSIZE_CSEC NUMBER fileid, -- FILE_ID NUMBER creationtime, -- CREATION_TIME NUMBER avrdtime, -- AVERAGE_READ_TIME NUMBER avwrtime, -- AVERAGE_WRITE_TIME NUMBER phyread, -- PHYSICAL_READS NUMBER phywrite, -- PHYSICAL_WRITES NUMBER phybkrd, -- PHYSICAL_BLOCK_READS NUMBER phybkwr -- PHYSICAL_BLOCK_WRITES NUMBER FROM x$kewmflmv

home |  up  |  mailbox