diskio.sql

--==================================================================
--
-- Title       :   diskio.sql
-- Description :   To show total reads, writes and the sum of reads
--                 and writes for each database (dbf) file.
--
-- Usage/Notes :
--
-- Copyright   :   ABCdba.com 2002
--
--==================================================================
 
CLEAR BREAKS
CLEAR COLUMNS
CLEAR COMPUTES
 
COL name HEA "Data File Name" FOR a45
COL phyrds HEA "Reads" FOR 99999999
COL phywrts HEA "Write" FOR 99999999
COL total_io HEA "Total io" FOR 99999999
 
SET PAGES 50
 
SELECT name, phywrts, phyrds, (phywrts + phyrds) total_io
FROM v$dbfile df, v$filestat fs
WHERE df.file# = fs.file#
ORDER BY (phywrts + phyrds) desc, name
/
 
SET PAGES 20

© copyright 2001-2014 ABCdba.com | all rights reserved