[20181103]12c视图V$EVENT_NAME.txt

[20181103]12c视图V$EVENT_NAME.txt --//12c的V$EVENT_NAME增加一个字段display_name,能更好地说明描述等待事件: SCOTT@test01p> @ ver1 PORT_STRING                    VERSION        BANNER                                                                               CON_ID ------------------------------ -------------- -------------------------------------------------------------------------------- ---------- IBMPC/WIN_NT64-9.1.0           12.2.0.1.0     Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production              0 SCOTT@test01p> column con_id noprint SCOTT@test01p> select * from v$event_name where display_name != name order by 1,2; EVENT#   EVENT_ID NAME                                 PARAMETER1 PARAMETER2 PARAMETER3 WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS     DISPLAY_NAME ------ ---------- ------------------------------------ ---------- ---------- ---------- ------------- ----------- -------------- -------------------------------------------     94 3213517201 control file sequential read         file#      block#     blocks        4108307767           9 System I/O     control file read     95 2383414886 control file single write            file#      block#     blocks        4108307767           9 System I/O     control file write    146  549236675 log file sequential read             log#       block#     blocks        4108307767           9 System I/O     log file multiblock read    147  215477332 log file single write                log#       block#     blocks        4108307767           9 System I/O     log file header write    148 3999721902 log file parallel write              files      blocks     requests      4108307767           9 System I/O     log file redo write    151 3357856061 log buffer space                                                         3290255840           2 Configuration  log buffer full - LGWR bottleneck    157 1328744198 log file sync                        buffer#    sync scn                 3386400367           5 Commit         commit: log file sync    161 1278638045 LGWR real time apply sync                                                2723168908           6 Idle           standby apply advance notification    164 2652584166 db file sequential read              file#      block#     blocks        1740759767           8 User I/O       db single block read    165  506183215 db file scattered read               file#      block#     blocks        1740759767           8 User I/O       db multiblock read    166 1307477558 db file single write                 file#      block#     blocks        1740759767           8 User I/O       db single block write    167 1620694733 db file parallel write               requests   interrupt  timeout       4108307767           9 System I/O     db list of blocks write    169  834992820 db file parallel read                files      blocks     requests      1740759767           8 User I/O       db list of blocks read    252 3525876136 wait for possible quiesce finish                                         4166625743           3 Administrative quiesce database completion    268 4031319789 concurrent I/O completion                                                4166625743           3 Administrative online move datafile IO completion    269 1845020027 datafile copy range completion                                           4166625743           3 Administrative online move datafile copy range completion    837 3839860880 Image redo gen delay                                                     1893977003           0 Other          redo resource management    850 1242352358 DFS db file lock                     file#                               1893977003           0 Other          quiesce for datafile offline   1000  930916630 datafile move cleanup during resize                                      1893977003           0 Other          online move datafile resize cleanup 19 rows selected. --//比如初学者比较容易混淆的db file scattered read解析为db multiblock read.db file sequential read解析为db single block --//read.