|
select
sid,serial#,username,osuser,program,machine,terminal
from v$session
where type = 'USER'; -- ユーザープロセス
SID SERIAL# USERNAME OSUSER PROGRAM MACHINE TERMINAL
---- ------- --------- ------ ---------- --------- --------
139 2 TEST Owner sqlplus.exe MATSU_XP MATSU_XP
144 20 SYSTEM ORACLE.EXE MATSU_XP MATSU_XP
|