select sid,serial#,username,program,machine,status from v$session order by username 转载于:https://www.cnblogs.com/xinlang/archive/2011/02/28/1966819.html