Skip to content

Instantly share code, notes, and snippets.

@aoflima
Created January 26, 2018 22:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aoflima/26785830df07c9e63224e28d62d6914a to your computer and use it in GitHub Desktop.
Save aoflima/26785830df07c9e63224e28d62d6914a to your computer and use it in GitHub Desktop.
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