爱于心健于行

原创 oracrl 查看链接 用户 及其操作 方便查看未释放的链接

SELECT osuser, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine 　　from v$session a, v$sqlarea b 　　where a.sql_address =b.address order by cpu_time/executions desc