Script to know I/O details in datafiles and letch contents details in oracle database:

Query to know  top 10 I/O details in Oracle datafiles:

SQL> !cat top10_io_datafiles.sql

set pages 1000 lines 180

col name for a100

select * from (

select name,phyrds, phywrts,readtim,writetim

from v$filestat a, v$datafile b

where a.file#=b.file#

order by phywrts desc) Where rownum<11;

Query to know Top 10 letch contends in Oracle Database:

select * from

 (select name, gets,misses,  sleeps

 from   v$latch

 order by sleeps desc)

 where rownum < 11;