[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.