Oracle I/O Monitoring Script

The script as below can be used to monitor the Oracle data files I/O. You may need to plan for data file redistribution if most of the I/O goes to the same physical mount point.

DB IO Monitoring

SELECT vfs.file#, dbf.file_name, dbf.tablespace_name, dbf.bytes, vfs.phyrds/vfs.phywrts,
vfs.phyblkrd/vfs.phyblkwrt, vfs.readtim, vfs.writetim f
rom V$FILESTAT vfs, DBA_DATA_FILES dbf
WHERE vfs.file# = dbf.file_id

Leave a Comment

Recent Posts

Recent Comments

shubhod salian: Hi Indu, You need to execute adadmin on node B , simply because your forms server resides on this...
hari: May I know what is the referred meta link for the permanent solution.
guru: Hi Indu, you just need to run once if your multi node apps environment is running on shared APPL_TOP...
indu: hi guru, my application is in multi node environment. admin, concurrent, report servers are in node A. form and...
Hussain: Thanks Guru for your quick and kind help.

RSS

RSS