Re: Number of Active user sessions

What about this -

select CURRENT YEAR TO SECOND,
sqx_sessionid,username,sd.odb_dbname,sqx_seqscan,sqx_sqlstatement
from syssqexplain sq, sysscblst sc , sysopendb sd
where sq.sqx_sessionid = sc.sid
and sc.sid = sd.odb_sessionid
and sd.odb_dbname <> 'sysmaster'
and length(sqx_sqlstatement) > 0
and sqx_sqlstatement not like "%tabid = 1%"

Have fun.

.