Sybase JDBC showplan in dbvisualizer set showplan on; set noexec on; infocenter.sybase.com select name, fullname, totio, totcpu, lastlogindate from master..syslogins where totio > 0 order by totio select hashkey, sequence, elap_min, elap_max, elap_avg, cnt, abort_cnt, qtext from sysquerymetrics sp_lock go SELECT * FROM master..sysprocesses WHERE time_blocked > 0 ORDER BY time_blocked DESC //need select on monlocks AND mon_role select count(*) from master..monlocks //who is holding locks SELECT H.spid 'Holding ID', H.fid 'Holding FID', SUSER_NAME(H.suid) 'Holding User', W.spid 'Waiting ID', W.fid 'Waiting FID', SUSER_NAME(W.suid) 'Waiting User', H.status 'Status', V.name 'Lock Type', W.time_blocked 'Time Blocked', DB_NAME(L.dbid) 'Database', OBJECT_NAME(L.id, L.dbid) 'Object Name', L.page 'Lock Page', L.class 'Lock Class', H.hostname 'Holding Host', W.hostname