WITH t AS (SELECT rownum num,salary.* FROM salary ) SELECT num,t.sal FROM t WHERE num>=6 AND num<=10;
1)这个问题不能单纯看DB、 ① OS层面、长时间运行,可能是某些进程出现异常,占用大量CPU资源:top ② 很多愚蠢的SQL都会令CPU跑满、 2)v$segment_statistics、v$session_ops、v$session_wait、 3) WITH t AS (SELECT rownum num,salary.* FROM salary ) SELECT num,t.sal FROM t WHERE num>=6 AND num<=10;
17,140
社区成员
55,259
社区内容
加载中
试试用AI创作助手写篇文章吧