GetLogHistory
emcs
49次下载
500次浏览
2019-07-24
4.5

脚本内容

alter session set nls_date_format='YYYY-MM-DD'; set linesize 130 set pagesize 99 col Day for a6 col Total for 99999 col h0 for 99 col h1 for 99 col h2 for 99 col h3 for 99 col h4 for 99 col h5 for 99 col h6 for 99 col h7 for 99 col h8 for 99 col h9 for 99 col h10 for 99 col h11 for 99 col h12 for 99 col h13 for 99 col h14 for 99 col h15 for 99 col h16 for 99 col h17 for 99 col h18 for 99 col h19 for 99 col h20 for 99 col h21 for 99 col h22 for 99 col h23 for 99 col h24 for 99 SELECT trunc(first_time) "Date", to_char(first_time, 'Dy') "Day", count(1) "Total", SUM(decode(to_char(first_time, 'hh24'),'00',1,0)) "h0", SUM(decode(to_char(first_time, 'hh24'),'01',1,0)) "h1", SUM(decode(to_char(first_time, 'hh24'),'02',1,0)) "h2", SUM(decode(to_char(first_time, 'hh24'),'03',1,0)) "h3", SUM(decode(to_char(first_time, 'hh24'),'04',1,0)) "h4", SUM(decode(to_char(first_time, 'hh24'),'05',1,0)) "h5", SUM(decode(to_char(first_time, 'hh24'),'06',1,0)) "h6", SUM(decode(to_char(first_time, 'hh24'),'07',1,0)) "h7", SUM(decode(to_char(first_time, 'hh24'),'08',1,0)) "h8", SUM(decode(to_char(first_time, 'hh24'),'09',1,0)) "h9", SUM(decode(to_char(first_time, 'hh24'),'10',1,0)) "h10", SUM(decode(to_char(first_time, 'hh24'),'11',1,0)) "h11", SUM(decode(to_char(first_time, 'hh24'),'12',1,0)) "h12", SUM(decode(to_char(first_time, 'hh24'),'13',1,0)) "h13", SUM(decode(to_char(first_time, 'hh24'),'14',1,0)) "h14", SUM(decode(to_char(first_time, 'hh24'),'15',1,0)) "h15", SUM(decode(to_char(first_time, 'hh24'),'16',1,0)) "h16", SUM(decode(to_char(first_time, 'hh24'),'17',1,0)) "h17", SUM(decode(to_char(first_time, 'hh24'),'18',1,0)) "h18", SUM(decode(to_char(first_time, 'hh24'),'19',1,0)) "h19", SUM(decode(to_char(first_time, 'hh24'),'20',1,0)) "h20", SUM(decode(to_char(first_time, 'hh24'),'21',1,0)) "h21", SUM(decode(to_char(first_time, 'hh24'),'22',1,0)) "h22", SUM(decode(to_char(first_time, 'hh24'),'23',1,0)) "h23" FROM V$log_history where trunc(first_time)>sysdate-30 group by trunc(first_time), to_char(first_time, 'Dy') Order by 1; alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';

评论

贡献排行榜