在Oracle database 12c 中引入V$EVENT_NAME 视图新增字段DISPLAY_NAME，该字段用以更详细地解释对应的等待事件：
DISPLAY_NAME |
VARCHAR2(64) |
A clearer and more descriptive name for the wait event that appears in the NAME column. Names that appear in the DISPLAY_NAME column can change across Oracle Database releases, therefore customer scripts should not rely on names that appear in theDISPLAY_NAME column across releases. |
可惜的是目前并非所有的event都有对应的DISPLAY_NAME，我们列出在12.1.0.1中现有的display name:
select name,display_name,wait_class from v$event_name where name!=display_name order by name
| NAME | DISPLAY_NAME | WAIT_CLASS |
| DFS db file lock | quiesce for datafile offline | Other |
| Image redo gen delay | redo resource management | Other |
| LGWR real time apply sync | standby apply advance notification | Idle |
| concurrent I/O completion | online move datafile IO completion | Administrative |
| control file sequential read | control file read | System I/O |
| control file single write | control file write | System I/O |
| datafile copy range completion | online move datafile copy range completion | Administrative |
| datafile move cleanup during resize | online move datafile resize cleanup | Other |
| db file parallel read | db list of blocks read | User I/O |
| db file parallel write | db list of blocks write | System I/O |
| db file scattered read | db multiblock read | User I/O |
| db file sequential read | db single block read | User I/O |
| db file single write | db single block write | User I/O |
| log buffer space | log buffer full – LGWR bottleneck | Configuration |
| log file parallel write | log file redo write | System I/O |
| log file sequential read | log file multiblock read | System I/O |
| log file single write | log file header write | System I/O |
| log file sync | commit: log file sync | Commit |
| wait for possible quiesce finish | quiesce database completion | Administrative |
Leave a Reply