![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
hankxh
这个作者很懒,什么都没留下…
展开
-
Oracle连接数查询操作
1、查询库的连接状态:select b.MACHINE,b.PROGRAM,count(*) from v$process a, v$session b where a.ADDR = b.PADDR and b.USERNAME is not null group by b.MACHINE , b.PROGRAM order by count(*) desc;2、查询数据库当前支持的连接数...原创 2018-06-04 14:38:44 · 4068 阅读 · 0 评论 -
oracle锁表查询及定位
--查询锁表select sess.sid, sess.serial#, lo.oracle_username, lo.os_user_name, ao.object_name, lo.locked_mode from v$locked_object lo, dba_objects ao, v$session sess where a...原创 2018-06-19 16:46:05 · 507 阅读 · 0 评论