12c DISPLAY_NAME column in v$event_name view

in 12c Oracle has introduced and new field in the v$event_name view called DISPLAY_NAME.

After review the contents on more then 1800 events, I noticed the most display name were the same as the name with exception of a 19.

Here are they:

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.

view raw
display_name.txt
hosted with ❤ by GitHub

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.