| 1 |
DESC sys.session; |
| 2 |
Field Type Null Key Default Extra |
| 3 |
thd_id bigint(20) unsigned NO NULL |
| 4 |
conn_id bigint(20) unsigned YES NULL |
| 5 |
user varchar(384) YES NULL |
| 6 |
db varchar(64) YES NULL |
| 7 |
command varchar(16) YES NULL |
| 8 |
state varchar(64) YES NULL |
| 9 |
time bigint(20) YES NULL |
| 10 |
current_statement longtext YES NULL |
| 11 |
statement_latency varchar(12) YES NULL |
| 12 |
progress decimal(26,2) YES NULL |
| 13 |
lock_latency varchar(12) YES NULL |
| 14 |
rows_examined bigint(20) unsigned YES NULL |
| 15 |
rows_sent bigint(20) unsigned YES NULL |
| 16 |
rows_affected bigint(20) unsigned YES NULL |
| 17 |
tmp_tables bigint(20) unsigned YES NULL |
| 18 |
tmp_disk_tables bigint(20) unsigned YES NULL |
| 19 |
full_scan varchar(3) YES NULL |
| 20 |
last_statement longtext YES NULL |
| 21 |
last_statement_latency varchar(12) YES NULL |
| 22 |
current_memory varchar(14) YES NULL |
| 23 |
last_wait varchar(128) YES NULL |
| 24 |
last_wait_latency varchar(13) YES NULL |
| 25 |
source varchar(64) YES NULL |
| 26 |
trx_latency varchar(12) YES NULL |
| 27 |
trx_state enum('ACTIVE','COMMITTED','ROLLED BACK') YES NULL |
| 28 |
trx_autocommit enum('YES','NO') YES NULL |
| 29 |
pid varchar(1024) YES NULL |
| 30 |
program_name varchar(1024) YES NULL |
| 31 |
SELECT * FROM sys.session; |
| 32 |
DESC sys.x$session; |
| 33 |
Field Type Null Key Default Extra |
| 34 |
thd_id bigint(20) unsigned NO NULL |
| 35 |
conn_id bigint(20) unsigned YES NULL |
| 36 |
user varchar(384) YES NULL |
| 37 |
db varchar(64) YES NULL |
| 38 |
command varchar(16) YES NULL |
| 39 |
state varchar(64) YES NULL |
| 40 |
time bigint(20) YES NULL |
| 41 |
current_statement longtext YES NULL |
| 42 |
statement_latency bigint(20) unsigned YES NULL |
| 43 |
progress decimal(26,2) YES NULL |
| 44 |
lock_latency bigint(20) unsigned YES NULL |
| 45 |
rows_examined bigint(20) unsigned YES NULL |
| 46 |
rows_sent bigint(20) unsigned YES NULL |
| 47 |
rows_affected bigint(20) unsigned YES NULL |
| 48 |
tmp_tables bigint(20) unsigned YES NULL |
| 49 |
tmp_disk_tables bigint(20) unsigned YES NULL |
| 50 |
full_scan varchar(3) YES NULL |
| 51 |
last_statement longtext YES NULL |
| 52 |
last_statement_latency bigint(20) unsigned YES NULL |
| 53 |
current_memory decimal(41,0) YES NULL |
| 54 |
last_wait varchar(128) YES NULL |
| 55 |
last_wait_latency varchar(20) YES NULL |
| 56 |
source varchar(64) YES NULL |
| 57 |
trx_latency bigint(20) unsigned YES NULL |
| 58 |
trx_state enum('ACTIVE','COMMITTED','ROLLED BACK') YES NULL |
| 59 |
trx_autocommit enum('YES','NO') YES NULL |
| 60 |
pid varchar(1024) YES NULL |
| 61 |
program_name varchar(1024) YES NULL |
| 62 |
SELECT * FROM sys.x$session; |