45 lines
1.6 KiB
Plaintext
45 lines
1.6 KiB
Plaintext
DESC sys.schema_table_statistics;
|
|
Field Type Null Key Default Extra
|
|
table_schema varchar(64) YES NULL
|
|
table_name varchar(64) YES NULL
|
|
total_latency text YES NULL
|
|
rows_fetched bigint(20) unsigned NO NULL
|
|
fetch_latency text YES NULL
|
|
rows_inserted bigint(20) unsigned NO NULL
|
|
insert_latency text YES NULL
|
|
rows_updated bigint(20) unsigned NO NULL
|
|
update_latency text YES NULL
|
|
rows_deleted bigint(20) unsigned NO NULL
|
|
delete_latency text YES NULL
|
|
io_read_requests decimal(42,0) YES NULL
|
|
io_read text YES NULL
|
|
io_read_latency text YES NULL
|
|
io_write_requests decimal(42,0) YES NULL
|
|
io_write text YES NULL
|
|
io_write_latency text YES NULL
|
|
io_misc_requests decimal(42,0) YES NULL
|
|
io_misc_latency text YES NULL
|
|
SELECT * FROM sys.schema_table_statistics;
|
|
DESC sys.x$schema_table_statistics;
|
|
Field Type Null Key Default Extra
|
|
table_schema varchar(64) YES NULL
|
|
table_name varchar(64) YES NULL
|
|
total_latency bigint(20) unsigned NO NULL
|
|
rows_fetched bigint(20) unsigned NO NULL
|
|
fetch_latency bigint(20) unsigned NO NULL
|
|
rows_inserted bigint(20) unsigned NO NULL
|
|
insert_latency bigint(20) unsigned NO NULL
|
|
rows_updated bigint(20) unsigned NO NULL
|
|
update_latency bigint(20) unsigned NO NULL
|
|
rows_deleted bigint(20) unsigned NO NULL
|
|
delete_latency bigint(20) unsigned NO NULL
|
|
io_read_requests decimal(42,0) YES NULL
|
|
io_read decimal(41,0) YES NULL
|
|
io_read_latency decimal(42,0) YES NULL
|
|
io_write_requests decimal(42,0) YES NULL
|
|
io_write decimal(41,0) YES NULL
|
|
io_write_latency decimal(42,0) YES NULL
|
|
io_misc_requests decimal(42,0) YES NULL
|
|
io_misc_latency decimal(42,0) YES NULL
|
|
SELECT * FROM sys.x$schema_table_statistics;
|