Find Top 5 Datafiles with highest I/O activity

col name format a40
set linesize 140
select * from (select name,phyrds, phywrts,readtim,writetimfrom v$filestat a, v$datafile b 
where a.file#=b.file#order by readtim desc) where rownum <6; 

1 comment:

  1. JavaScript is the most popular client-side scripting language supported by all browsers. It is used for wide-ranging browser functionalities like validating forms, creating cookies, and more. Moreover, it is considered a high-demanding programming language in the current job market. Decent knowledge of JavaScript programming language not only helps you get a good job but also gives you an edge in your current job as well. free SQL Server courses