List all Active Sessions

-- sessions.sql

select sid,

username,

pid,

hostname,

l2date(connected) startdate -- convert unix time to date

from syssessions

Sample Output

sid username pid hostname startdate

47 lester 11564 merlin 07/14/1997

Previous slide

Next slide

Back to first slide

View graphic version