sys Schema Stored Procedures The  waits_by_user_by_latency  and  x$waits_by_user_by_latency  views have these columns: The user associated with the connection. The event name. The total number of occurrences of the event for the user. The total wait time of timed occurrences of the event for the user. The average wait time per timed occurrence of the event for the user. The maximum single wait time of timed occurrences of the event for the user. 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: The event name. The total number of occurrences of the event. The total wait time of timed occurrences of the event. The average wait time per timed occurrence of the event. The maximum single wait time of timed occurrences of the event. The following sections describe  sys  schema stored procedures. 5182 28.4.4.1 The create_synonym_db() Procedure 28.4.4 sys Schema Stored Procedures • max_latency • avg_latency • total_latency • total • events • max_latency • avg_latency • total_latency • total • event • user 28.4.3.52 The waits_global_by_latency and x$waits_global_by_latency Views