select *
from (select s.SQL_TEXT,
s.EXECUTIONS "执行次数",
s.PARSING_USER_ID "用户名",
rank() over(order by EXECUTIONS desc) EXEC_RANK
from v$sql s
left join all_users u
on u.USER_ID = s.PARSING_USER_ID) t
where exec_rank <= 100;
https://www.cndba.cn/hbhe0316/article/4951
https://www.cndba.cn/hbhe0316/article/4951
https://www.cndba.cn/hbhe0316/article/4951
https://www.cndba.cn/hbhe0316/article/4951
https://www.cndba.cn/hbhe0316/article/4951
https://www.cndba.cn/hbhe0316/article/4951
https://www.cndba.cn/hbhe0316/article/4951
https://www.cndba.cn/hbhe0316/article/4951
https://www.cndba.cn/hbhe0316/article/4951
https://www.cndba.cn/hbhe0316/article/4951
版权声明:本文为博主原创文章,未经博主允许不得转载。
oracle,linux