Doc

Name: DFIO.sql

Author: Mahnho Han

Display the Datafile I/O rate for the specified tablespace.

#

SET PAGESIZE 60

SELECT FILE_NAME,PHYRDS,PHYWRTS,PHYRDS+PHYWRTS

FROM V$FILESTAT FS,DBA_DATA_FILES DF

WHERE DF.TABLESPACE_NAME = '&TABLESPACE'

AND FS.FILE# = DF.FILE_ID;