Toad AWR Browser lists Top events.
One of the fields displayed is Time Waited, but not units are provided.
What are the units for "Time Waited"?
The dba_hist_system_event view displays information about the count of total waits and time waited in microseconds.
Additional Information:
An example query that is executed in Toad for Oracle background:
select w.snap_id,
sn.BEGIN_INTERVAL_TIME,
w.event_name event,
w.wait_class,
w.total_waits - w.last_wait waits,
w.total_timeouts - w.last_timeout timeouts,
w.time_waited - w.last_time_waited time_waited
from SYS.DBA_HIST_snapshot sn,
(select snap_id, dbid, instance_number, event_name,
wait_class,
total_waits,
lag(total_waits, 1) over (order by event_name, snap_id) last_wait,
total_timeouts,
lag(total_timeouts, 1) over (order by event_name, snap_id) last_timeout,
time_waited_micro time_waited,
lag(time_waited_micro, 1) over (order by event_name, snap_id) last_time_waited
from SYS.DBA_HIST_system_event
where event_name not in (select name from SYS.V_$EVENT_NAME WHERE WAIT_CLASS = 'Idle')
and snap_id in (4841,4842,4843,4844,4845,4846,4847,4848,4849,4850,4851,4852,4853,4854,4855,4856,4857,4858,4859,4860,4861,4862,4863,4864,4865,4866,4867,4868,4869,4870,4871,4872,4873,4874,4875,4876,4877,4878,4879,4880,4881,4882,4883,4884,4885,4886,4887,4888,4889,4890,4891,4892,4893,4894,4895,4896,4897,4898,4899,4900,4901,4902,4903,4904,4905,4906,4907,4908,4909,4910,4911,4912,4913,4914,4915,4916,4917,4918,4919,4920,4921,4922,4923,4924,4925,4926,4927,4928,4929,4930,4931,4932,4933,4934,4935,4936,4937,4938,4939,4940,4941,4942,4943,4944,4945,4946,4947,4948,4949,4950,4951,4952,4953,4954,4955,4956,4957,4958,4959,4960,4961,4962,4963,4964,4965,4966,4967,4968,4969,4970,4971,4972,4973,4974,4975,4976,4977,4978,4979,4980,4981,4982,4983,4984,4985,4986,4987,4988,4989,4990,4991,4992,4993,4994,4995,4996,4997,4998,4999,5000,5001,5002,5003,5004,5005,5006,5007,5008,5009,5010,5011,5012,5013,5014,5015,5016,5017,5018,5019,5020,5021,5022,5023,5024,5025,5026,5027,5028,5029,5030,5031,5032,5033,5034,5035,5036,5037,5038,5039,5040,5041,5042,5043)
) w
where w.time_waited - w.last_time_waited > 0
and w.snap_id > 4841
and sn.snap_id = w.snap_id
and sn.dbid = w.dbid
and sn.instance_number = w.instance_number
order by 1, 7 desc
