首页 > 数据库 > Oracle > 正文

oracle性能调校

2024-08-29 13:42:01
字体:
来源:转载
供稿:网友
select * from v$sesstat order by STATISTIC# desc;查找游标 select SQL_TEXT, COUNT(*) from v$open_cursor group by SQL_TEXT order by COUNT(*);
select SID, COUNT(*) from v$open_cursor group by SID order by COUNT(*);
select COUNT(*) from v$open_cursor;

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表