bug 问题解决了,网上有,全表扫没了, db file sequential read事件
SQL> SELECT sid,event,p1text,p2text,p3text,wait_time,seconds_in_wait
2 FROM v$session_wait@dbverify
3 WHERE wait_class<>'idle' AND EVENT<>'SQL*Net message from client' order by seconds_in_wait desc;
SID EVENT P1TEXT P2TEXT P3TEXT WAIT_TIME SECONDS_IN_WAIT
---------- ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- ---------- ---------------
1604 Streams AQ: waiting for time management or cleanup tasks 0 3685665
1441 Backup: sbtbackup 0 788672
1245 Backup: sbtbackup 0 788668
1057 Backup: sbtbackup 0 788667
1456 Backup: sbtbackup 0 788665
1016 Backup: sbtbackup 0 788151
1019 Backup: sbtbackup 0 782456
1202 Backup: sbtbackup 0 781502
1058 Backup: sbtbackup 0 779891
1229 Backup: sbtbackup 0 778866
1642 rdbms ipc message timeout 0 305950
1618 ASM background timer 0 175880
1310 class slave wait slave id 0 105110
1654 DIAG idle wait component where wait time(millisec) 0 3083
1655 pmon timer duration 0 3034
1212 Streams AQ: qmn slave idle wait 0 2656
1653 rdbms ipc message timeout 0 441
1634 rdbms ipc message timeout 0 210
1648 gcs remote message waittime poll event 0 198
1631 rdbms ipc message timeout