sql 查看Oralce 数据库连接状态

select sid,serial#,username,program,machine,status
from v$session
order by username