Oracle查询各个用户下的连接数,需要管理员权限
SELECT
username,
COUNT(username)
FROM
v$session
WHERE
username IS NOT NULL
GROUP BY
username;
Oracle查询各个用户下的连接数,需要管理员权限
SELECT
username,
COUNT(username)
FROM
v$session
WHERE
username IS NOT NULL
GROUP BY
username;