sys Schema Views The statement digest. 28.4.3.40 The statements_with_temp_tables and x$statements_with_temp_tables Views 28.4.3.41 The user_summary and x$user_summary 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: 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 internal in-memory temporary tables created by occurrences of the statement. The total number of internal on-disk temporary tables created by occurrences of the statement. The average number of internal temporary tables created per occurrence of the statement. The percentage of internal in-memory temporary tables that were converted to on-disk tables. The time at which the statement was first seen. The time at which the statement was most recently seen. 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. • digest • last_seen • first_seen • tmp_tables_to_disk_pct • avg_tmp_tables_per_query • disk_tmp_tables • memory_tmp_tables • total_latency • exec_count • db • query 5175