sys Schema Views • digest The statement digest. These views list normalized statements that have performed sorts. By default, rows are sorted by descending total latency. The  statements_with_sorting  and  x$statements_with_sorting  views have these columns: The normalized statement string. The default database for the statement, or  NULL  if there is none. The total number of times the statement has executed. The total wait time of timed occurrences of the statement. The total number of sort merge passes by occurrences of the statement. The average number of sort merge passes per occurrence of the statement. The total number of sorts using table scans by occurrences of the statement. The total number of sorts using range accesses by occurrences of the statement. The total number of rows sorted by occurrences of the statement. The average number of rows sorted per occurrence of the statement. The time at which the statement was first seen. The time at which the statement was most recently seen. 5174 28.4.3.39 The statements_with_sorting and x$statements_with_sorting Views • query • db • exec_count • total_latency • sort_merge_passes • avg_sort_merges • sorts_using_scans • sort_using_range • rows_sorted • avg_rows_sorted • first_seen • last_seen • digest