DESC sys.session;
Field	Type	Null	Key	Default	Extra
thd_id	bigint(20) unsigned	NO		NULL	
conn_id	bigint(20) unsigned	YES		NULL	
user	varchar(384)	YES		NULL	
db	varchar(64)	YES		NULL	
command	varchar(16)	YES		NULL	
state	varchar(64)	YES		NULL	
time	bigint(20)	YES		NULL	
current_statement	longtext	YES		NULL	
statement_latency	mediumtext	YES		NULL	
progress	decimal(26,2)	YES		NULL	
lock_latency	text	YES		NULL	
rows_examined	bigint(20) unsigned	YES		NULL	
rows_sent	bigint(20) unsigned	YES		NULL	
rows_affected	bigint(20) unsigned	YES		NULL	
tmp_tables	bigint(20) unsigned	YES		NULL	
tmp_disk_tables	bigint(20) unsigned	YES		NULL	
full_scan	varchar(3)	YES		NULL	
last_statement	longtext	YES		NULL	
last_statement_latency	mediumtext	YES		NULL	
current_memory	text	YES		NULL	
last_wait	varchar(128)	YES		NULL	
last_wait_latency	mediumtext	YES		NULL	
source	varchar(64)	YES		NULL	
trx_latency	text	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.session;
DESC sys.x$session;
Field	Type	Null	Key	Default	Extra
thd_id	bigint(20) unsigned	NO		NULL	
conn_id	bigint(20) unsigned	YES		NULL	
user	varchar(384)	YES		NULL	
db	varchar(64)	YES		NULL	
command	varchar(16)	YES		NULL	
state	varchar(64)	YES		NULL	
time	bigint(20)	YES		NULL	
current_statement	longtext	YES		NULL	
statement_latency	bigint(20) unsigned	YES		NULL	
progress	decimal(26,2)	YES		NULL	
lock_latency	bigint(20) unsigned	YES		NULL	
rows_examined	bigint(20) unsigned	YES		NULL	
rows_sent	bigint(20) unsigned	YES		NULL	
rows_affected	bigint(20) unsigned	YES		NULL	
tmp_tables	bigint(20) unsigned	YES		NULL	
tmp_disk_tables	bigint(20) unsigned	YES		NULL	
full_scan	varchar(3)	YES		NULL	
last_statement	longtext	YES		NULL	
last_statement_latency	bigint(20) 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(20) 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$session;