1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
DESC sys.io_global_by_wait_by_latency;
Field Type Null Key Default Extra
event_name varchar(128) YES NULL
total bigint(20) unsigned NO NULL
total_latency varchar(12) YES NULL
avg_latency varchar(12) YES NULL
max_latency varchar(12) YES NULL
read_latency varchar(12) YES NULL
write_latency varchar(12) YES NULL
misc_latency varchar(12) YES NULL
count_read bigint(20) unsigned NO NULL
total_read varchar(14) YES NULL
avg_read varchar(14) YES NULL
count_write bigint(20) unsigned NO NULL
total_written varchar(14) YES NULL
avg_written varchar(14) YES NULL
SELECT * FROM sys.io_global_by_wait_by_latency;
DESC sys.x$io_global_by_wait_by_latency;
Field Type Null Key Default Extra
event_name varchar(128) YES NULL
total bigint(20) unsigned NO NULL
total_latency bigint(20) unsigned NO NULL
avg_latency bigint(20) unsigned NO NULL
max_latency bigint(20) unsigned NO NULL
read_latency bigint(20) unsigned NO NULL
write_latency bigint(20) unsigned NO NULL
misc_latency bigint(20) unsigned NO NULL
count_read bigint(20) unsigned NO NULL
total_read bigint(20) NO NULL
avg_read decimal(23,4) NO 0.0000
count_write bigint(20) unsigned NO NULL
total_written bigint(20) NO NULL
avg_written decimal(23,4) NO 0.0000
SELECT * FROM sys.x$io_global_by_wait_by_latency;
|
