The waits_by_user_by_latency  and x$waits_by_user_by_latency  views have these columns: 

• user 

The user associated with the connection. 

• event 

The event name. 

• total 

The total number of occurrences of the event for the user. 

• total_latency 

The total wait time of timed occurrences of the event for the user. 

• avg_latency 

The average wait time per timed occurrence of the event for the user. 

• max_latency 

The maximum single wait time of timed occurrences of the event for the user. 

## 28.4.3.52 The waits_global_by_latency and x$waits_global_by_latency Views 

These views summarize wait events, grouped by event. By default, rows are sorted by descending total latency. Idle events are ignored. 

The waits_global_by_latency  and x$waits_global_by_latency  views have these columns: 

## 28.4.4 sys Schema Stored Procedures 

## 28.4.4.1 The create_synonym_db() Procedure 

• events 

The event name. 

• total 

The total number of occurrences of the event. 

• total_latency 

The total wait time of timed occurrences of the event. 

• avg_latency 

The average wait time per timed occurrence of the event. 

• max_latency 

The maximum single wait time of timed occurrences of the event. 

The following sections describe sys  schema stored procedures. 

