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

An Oracle Spin by Alex Lima