26.4.3.39 The statements_with_sorting and x$statements_with_sorting Views
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:
-
queryThe normalized statement string.
-
dbThe default database for the statement, or
NULLif there is none. -
exec_countThe total number of times the statement has executed.
-
total_latencyThe total wait time of timed occurrences of the statement.
-
sort_merge_passesThe total number of sort merge passes by occurrences of the statement.
-
avg_sort_mergesThe average number of sort merge passes per occurrence of the statement.
-
sorts_using_scansThe total number of sorts using table scans by occurrences of the statement.
-
sort_using_rangeThe total number of sorts using range accesses by occurrences of the statement.
-
rows_sortedThe total number of rows sorted by occurrences of the statement.
-
avg_rows_sortedThe average number of rows sorted per occurrence of the statement.
-
first_seenThe time at which the statement was first seen.
-
last_seenThe time at which the statement was most recently seen.
-
digestThe statement digest.
© 2025 Oracle
Licensed under the GPLv2 License.