Database Administration (MOSC)

MOSC Banner

What is the values of max/current I/O for a datafiles in MB per second?

edited Nov 24, 2009 3:21AM in Database Administration (MOSC) 3 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center