觉得可以通过一下方法分析一下 1、查询当前每个用户的连接个数 select username,count(username) from v$session where username is not null group by username; 2、查询当前用户正在执行的sql语句 SELECT b.sid oracleID, b.username, b.serial#, spid , paddr, sql_text , b.machine FROM v$process a, v$session b, v$sqlarea c WHERE a.addr = b.paddr AND b.sql_hash_value = c.hash_value
1、查询当前每个用户的连接个数
select username,count(username) from v$session where username is not null group by username;
2、查询当前用户正在执行的sql语句
SELECT b.sid oracleID,
b.username,
b.serial#,
spid ,
paddr,
sql_text ,
b.machine
FROM v$process a, v$session b, v$sqlarea c
WHERE a.addr = b.paddr
AND b.sql_hash_value = c.hash_value