复制select trunc(sample_time,记次及处 mi) tm, sql_id, nvl(event,CPU),count(distinct session_id) cnt from dba_hist_active_sess_history where sample_time between to_date(2019-09-03 9:30:00) and to_date(2019-09-03 11:00:00) group by trunc(sample_time, mi), sql_id,nvl(event,CPU) order by cnt desc; 1.2.3.4.5.6. |
喜欢
讨厌