
复制SELECT inst_id,关于EVENT, SUM(DECODE(WAIT_TIME, 0, 0, 1)) "Prev", SUM(DECODE(WAIT_TIME, 0, 1, 0)) "Curr", COUNT(*) "Tot" , sum(SECONDS_IN_WAIT) SECONDS_IN_WAIT FROM GV$SESSION_WAIT WHERE event NOT IN (smon timer,pmon timer,rdbms ipc message,SQL*Net message from client,gcs remote message) AND event NOTLIKE%idle% AND event NOTLIKE%Idle% AND event NOTLIKE%Streams AQ% GROUPBY inst_id,EVENT ORDERBY 1,5 desc; --class slave wait 1.2.3.4.5.6.7.8.9.10.11.