DESC sys.statements_with_temp_tables; Field Type Null Key Default Extra query longtext YES NULL db varchar(64) YES NULL exec_count bigint(20) unsigned NO NULL total_latency varchar(12) YES NULL memory_tmp_tables bigint(20) unsigned NO NULL disk_tmp_tables bigint(20) unsigned NO NULL avg_tmp_tables_per_query decimal(21,0) NO 0 tmp_tables_to_disk_pct decimal(24,0) NO 0 first_seen timestamp NO 0000-00-00 00:00:00 last_seen timestamp NO 0000-00-00 00:00:00 digest varchar(32) YES NULL SELECT * FROM sys.statements_with_temp_tables; DESC sys.x$statements_with_temp_tables; Field Type Null Key Default Extra query longtext YES NULL db varchar(64) YES NULL exec_count bigint(20) unsigned NO NULL total_latency bigint(20) unsigned NO NULL memory_tmp_tables bigint(20) unsigned NO NULL disk_tmp_tables bigint(20) unsigned NO NULL avg_tmp_tables_per_query decimal(21,0) NO 0 tmp_tables_to_disk_pct decimal(24,0) NO 0 first_seen timestamp NO 0000-00-00 00:00:00 last_seen timestamp NO 0000-00-00 00:00:00 digest varchar(32) YES NULL SELECT * FROM sys.x$statements_with_temp_tables;