2007-09-26

oracle 查看数据库连接备忘

关键字: oracle 
select count(*) from v$session where username is not null order by machine;
select * from v$session where username is not null order by machine;
select count(*) from v$session where username is not null and machine='test1' order by machine ;
select count(*) from v$session where username is not null and machine='localhost.localdomain' order by machine ;
select * from v$process where username is not null ;
select * from V$SHARED_SERVER_MONITOR ;
SELECT * FROM v$open_cursor;
SELECT sql_text,COUNT(*) FROM v$sql s , v$session se WHERE se.prev_hash_value =s.hash_value GROUP BY sql_text;
评论
发表评论

您还没有登录，请登录后发表评论

yezi
搜索本博客
我的相册
76988825-a3a2-35e4-b837-75437d40ffca-thumb
IMG_7195
共 46 张
最近加入圈子
存档
最新评论