What tables have the most I/O?

-- tabprofile.sql

select

dbsname,

tabname,

-- uncomment the following lines as needed to show specific values

isreads,

-- bufreads,

-- pagreads

iswrites,

-- bufwrites,

-- pagwrites

lockreqs

-- lockwts,

-- deadlks

from sysptprof

order by isreads desc; -- change this sort to whatever you need to monitor.

Previous slide

Next slide

Back to first slide

View graphic version