SELECT v.*, s.* FROM v$session s ,v$sesstat v WHERE v.sid = s.sid AND v.statistic# = 4 AND s.username = 'XXPDA' ; SELECT * FROM v$sesstat v;