1. Home
  2. Knowledge Base
  3. Performance Tuning
  4. Script – Datafiles with highest I/O activity
  1. Home
  2. Knowledge Base
  3. Scripts
  4. Script – Datafiles with highest I/O activity

Script – Datafiles with highest I/O activity

col name format a40
set linesize 140
select * from (
select name,phyrds, phywrts,readtim,writetim
from v$filestat a, v$datafile b
where a.file#=b.file#
order by readtim desc) where rownum <6;
The following two tabs change content below.

Gavin Soorma

Latest posts by Gavin Soorma (see all)

Updated on June 2, 2021

Was this article helpful?

Related Articles

Leave a Comment