What is the values of max/current I/O for a datafiles in MB per second?
please, explain me in detail what is the meaning of these columns:
dba_hist_filestatxs.readteam - over what period?
dba_hist_filestatxs.phyblkrd - over what period?
Could I interpret ROUND(phyblkrd/readtim*100, 3)) as reads in second?
v$filemetric.average_read_time - over what period?
v$filemetric.physical_reads - over what period?
Could I interpret ROUND(physical_reads/intsize_csec, 3)) as reads in second?
My questions that I need to know
1. I want to get a values of max/current I/O for a datafiles in MB per second.
2. I want to get a vaues of max/current I/O for storage in MB per second.
dba_hist_filestatxs.readteam - over what period?
dba_hist_filestatxs.phyblkrd - over what period?
Could I interpret ROUND(phyblkrd/readtim*100, 3)) as reads in second?
v$filemetric.average_read_time - over what period?
v$filemetric.physical_reads - over what period?
Could I interpret ROUND(physical_reads/intsize_csec, 3)) as reads in second?
My questions that I need to know
1. I want to get a values of max/current I/O for a datafiles in MB per second.
2. I want to get a vaues of max/current I/O for storage in MB per second.
0