The statement digest. 

## 28.4.3.40 The statements_with_temp_tables and x$statements_with_temp_tables Views 

These views list normalized statements that have used temporary tables. By default, rows are sorted by descending number of on-disk temporary tables used and descending number of in-memory temporary tables used. 

The statements_with_temp_tables  and x$statements_with_temp_tables  views have these columns: 

• query 

The normalized statement string. 

• db 

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

• exec_count 

The total number of times the statement has executed. 

• total_latency 

The total wait time of timed occurrences of the statement. 

• memory_tmp_tables 

The total number of internal in-memory temporary tables created by occurrences of the statement. 

• disk_tmp_tables 

The total number of internal on-disk temporary tables created by occurrences of the statement. 

• avg_tmp_tables_per_query 

The average number of internal temporary tables created per occurrence of the statement. 

• tmp_tables_to_disk_pct 

The percentage of internal in-memory temporary tables that were converted to on-disk tables. 

## 28.4.3.41 The user_summary and x$user_summary Views 

• 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. 

These views summarize statement activity, file I/O, and connections, grouped by user. By default, rows are sorted by descending total latency. 

