26.4.3.38 The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile Views

These views list statements with runtimes in the 95th percentile. By default, rows are sorted by descending average latency.

Both views use two helper views, x$ps_digest_avg_latency_distribution and x$ps_digest_95th_percentile_by_avg_us.

query

The normalized statement string.
db

The default database for the statement, or NULL if there is none.
full_scan

The total number of full table scans performed by occurrences of the statement.
exec_count

The total number of times the statement has executed.
err_count

The total number of errors produced by occurrences of the statement.
warn_count

The total number of warnings produced by occurrences of the statement.
total_latency

The total wait time of timed occurrences of the statement.
max_latency

The maximum single wait time of timed occurrences of the statement.
avg_latency

The average wait time per timed occurrence of the statement.
rows_sent

The total number of rows returned by occurrences of the statement.
rows_sent_avg

The average number of rows returned per occurrence of the statement.
rows_examined

The total number of rows read from storage engines by occurrences of the statement.
rows_examined_avg

The average number of rows read from storage engines per occurrence of the statement.
first_seen

The time at which the statement was first seen.
last_seen

The time at which the statement was most recently seen.
digest

The statement digest.