Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SQL> select name, display_name, wait_class from v$event_name where name != display_name;
NAME DISPLAY_NAME WAIT_CLASS
---------------------------------------------------------------- ---------------------------------------------------------------- ----------------------------------------------------------------
control file sequential read control file read System I/O
control file single write control file 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 parallel write log file redo write System I/O
log buffer space log buffer full - LGWR bottleneck Configuration
log file sync commit: log file sync Commit
LGWR real time apply sync standby apply advance notification Idle
db file sequential read db single block read User I/O
db file scattered read db multiblock read User I/O
db file single write db single block write User I/O
db file parallel write db list of blocks write System I/O
db file parallel read db list of blocks read User I/O
wait for possible quiesce finish quiesce database completion Administrative
concurrent I/O completion online move datafile IO completion Administrative
datafile copy range completion online move datafile copy range completion Administrative
Image redo gen delay redo resource management Other
DFS db file lock quiesce for datafile offline Other
datafile move cleanup during resize online move datafile resize cleanup Other
19 rows selected.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.