db file sequential read 系列事件的定位

1、查看数据库的等待事件：

         INST_ID EVENT                                                     Prev             Curr              Tot  SECONDS_IN_WAIT
---------------- --------------------------------------------- ---------------- ---------------- ---------------- ----------------
               1 db file sequential read                                      0                9                9                0
               1 jobq slave wait                                              0                3                3                0
               1 LNS ASYNC end of log                                         0                1                1                0
               1 SQL*Net message to client                                    1                0                1                0

2、查出等待事件发生所在的文件号和块号

11:44:46 sys@ORADB1>SELECT p1 "file#", p2 "block#", p