SELECT
b.sid AS oracleID,
b.username AS 登录Oracle用户名,
b.serial#,
spid AS 操作系统ID,
paddr,
sql_text AS 正在执行的SQL,
b.machine AS 计算机名
FROM
v$process a,
v$SESSION b,
v$sqlarea c
WHERE
a.addr = b.paddr
AND b.sql_hash_value = c.hash_value
SELECT
b.sid AS oracleID,
b.username AS 登录Oracle用户名,
b.serial#,
spid AS 操作系统ID,
paddr,
sql_text AS 正在执行的SQL,
b.machine AS 计算机名
FROM
v$process a,
v$SESSION b,
v$sqlarea c
WHERE
a.addr = b.paddr
AND b.sql_hash_value = c.hash_value