DESC sys.processlist; Field Type Null Key Default Extra thd_id bigint unsigned NO NULL conn_id bigint unsigned YES NULL user varchar(288) YES NULL db varchar(64) YES NULL command varchar(16) YES NULL state varchar(64) YES NULL time bigint YES NULL current_statement longtext YES NULL statement_latency varchar(11) YES NULL progress decimal(26,2) YES NULL lock_latency varchar(11) YES NULL rows_examined bigint unsigned YES NULL rows_sent bigint unsigned YES NULL rows_affected bigint unsigned YES NULL tmp_tables bigint unsigned YES NULL tmp_disk_tables bigint unsigned YES NULL full_scan varchar(3) NO last_statement longtext YES NULL last_statement_latency varchar(11) YES NULL current_memory varchar(11) YES NULL last_wait varchar(128) YES NULL last_wait_latency varchar(13) YES NULL source varchar(64) YES NULL trx_latency varchar(11) YES NULL trx_state enum('ACTIVE','COMMITTED','ROLLED BACK') YES NULL trx_autocommit enum('YES','NO') YES NULL pid varchar(1024) YES NULL program_name varchar(1024) YES NULL SELECT * FROM sys.processlist; DESC sys.x$processlist; Field Type Null Key Default Extra thd_id bigint unsigned NO NULL conn_id bigint unsigned YES NULL user varchar(288) YES NULL db varchar(64) YES NULL command varchar(16) YES NULL state varchar(64) YES NULL time bigint YES NULL current_statement longtext YES NULL statement_latency bigint unsigned YES NULL progress decimal(26,2) YES NULL lock_latency bigint unsigned YES NULL rows_examined bigint unsigned YES NULL rows_sent bigint unsigned YES NULL rows_affected bigint unsigned YES NULL tmp_tables bigint unsigned YES NULL tmp_disk_tables bigint unsigned YES NULL full_scan varchar(3) NO last_statement longtext YES NULL last_statement_latency bigint unsigned YES NULL current_memory decimal(41,0) YES NULL last_wait varchar(128) YES NULL last_wait_latency varchar(20) YES NULL source varchar(64) YES NULL trx_latency bigint unsigned YES NULL trx_state enum('ACTIVE','COMMITTED','ROLLED BACK') YES NULL trx_autocommit enum('YES','NO') YES NULL pid varchar(1024) YES NULL program_name varchar(1024) YES NULL SELECT * FROM sys.x$processlist;