【oracle数据库查询最近一个小时内占用会话数的进程，并倒序排序】

er_得一

于 2024-06-09 21:29:40 发布

阅读量179

点赞数 3

文章标签： oracle 数据库

本文链接：https://blog.youkuaiyun.com/qq_37667269/article/details/139566477

版权

oracle数据库查询最近一个小时内占用会话数的进程，并倒序排序

with a as 
(SELECT 
s.terminal,
s.logon_time,
s.sid,
       s.serial#,
       p.spid AS "OS Process ID",
       s.username,
       s.program
FROM   v$session s,
       v$process p
WHERE  s.paddr = p.addr
and logon_time > SYSDATE - INTERVAL '1' HOUR
order by logon_time)

select program,count(*) from a group by program
order by count(*) desc