本文介绍了一系列针对Oracle数据库的SQL查询技巧，包括如何查看当前活跃会话、进程信息及打开的游标详情等。通过这些查询语句可以帮助数据库管理员更好地监控和管理数据库资源。
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;
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;
扫一扫
2万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
