select username,status,sid,serial# from v$session where MACHINE='WORKGROUP\COMPUTERNAME';
还有一种方法: select userenv('SESSIONID') from dual;
select username,status,sid,serial# from v$session where TRIM(MACHINE)='WORKGROUP\COMPUTERNAME';
这么多方法,似乎答案并不一致。应该是这两个吧,从v$session 中查询出的不同方法,只要查出SID:select sid from v$session where username=user;select username,status,sid,serial# from v$session where TRIM(MACHINE)='WORKGROUP\COMPUTERNAME';
select userenv('SESSIONID') from dual;
TRIM(MACHINE)='WORKGROUP\COMPUTERNAME';
TRIM(MACHINE)='WORKGROUP\COMPUTERNAME';