SELECT osuser, a.username,cpu_time/executions/1000000||'s', sql_fulltext,a.machine
from v$session a, v$sqlarea b
where a.sql_address =b.address order by cpu_time/executions desc
oracrl 查看链接 用户 及其操作 方便查看未释放的链接
最新推荐文章于 2021-04-10 20:23:53 发布
SELECT osuser, a.username,cpu_time/executions/1000000||'s', sql_fulltext,a.machine
from v$session a, v$sqlarea b
where a.sql_address =b.address order by cpu_time/executions desc