根据OEM会话等待数的阀值插入到记录表中(pl/sql);

本文链接：https://blog.youkuaiyun.com/launch_225/article/details/7087086

本文探讨了SQL中特定查询语句的操作优化，并详细解释了如何根据CPU等待类、用户I/O等待类以及其它等待类的数据量进行数据插入逻辑处理，确保数据一致性与效率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

declare
v_wait_class u_sys_info.wait_class%type;
v_qty        u_sys_info.qty%type;
cursor c_info is
select nvl(wait_class,'cpu'),qty
from u_sys_info;
begin
open c_info;
loop
          fetch c_info into v_wait_class,v_qty;
          exit when c_info%notfound;
case
     when v_wait_class='cpu' and v_qty>=40 then
          insert into u_sys_info2 select * from u_sys_info where wait_class=v_wait_class;
          commit;
     when v_wait_class='User I/O' and v_qty>=53 then
          insert into u_sys_info2 select * from u_sys_info where wait_class=v_wait_class;
          commit;
     when v_wait_class<>'cpu' and v_wait_class<>'User I/O' and v_qty>1.7 then
          insert into u_sys_info2 select * from u_sys_info
          where wait_class=(select wait_class from u_sys_info
                            where qty=(select max(qty) from u_sys_info
                                   where wait_class<>'cpu'
                                   and wait_class<>'User I/O'
                                   and qty>1.7));
          commit;
     else
          dbms_output.put_line('not exists');
end case;
end loop;
close c_info;
end;
/