Monitor Resource Usage by User

-- sesprof.sql

select username,

syssesprof.sid,

lockreqs,

bufreads,

bufwrites

from syssesprof, syssessions

where syssesprof.sid = syssessions.sid

order by bufreads desc

Previous slide

Next slide

Back to first slide

View graphic version