set linesize 200
set pagesize 100
column day format a15 heading 'Day'
column d_0 format a3 heading '00'
column d_1 format a3 heading '01'
column d_2 format a3 heading '02'
column d_3 format a3 heading '03'
column d_4 format a3 heading '04'
column d_5 format a3 heading '05'
column d_6 format a3 heading '06'
column d_7 format a3 heading '07'
column d_8 format a3 heading '08'
column d_9 format a3 heading '09'
column d_10 format a3 heading '10'
column d_11 format a3 heading '11'
column d_12 format a3 heading '12'
column d_13 format a3 heading '13'
column d_14 format a3 heading '14'
column d_15 format a3 heading '15'
column d_16 format a3 heading '16'
column d_17 format a3 heading '17'
column d_18 format a3 heading '18'
column d_19 format a3 heading '19'
column d_20 format a3 heading '20'
column d_21 format a3 heading '21'
column d_22 format a3 heading '22'
column d_23 format a3 heading '23'

select
        substr(to_char(FIRST_TIME,'YYYY/MM/DD,DY'),1,15) day,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'00',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'00',1,0))) d_0,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'01',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'01',1,0))) d_1,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'02',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'02',1,0))) d_2,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'03',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'03',1,0))) d_3,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'04',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'04',1,0))) d_4,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'05',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'05',1,0))) d_5,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'06',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'06',1,0))) d_6,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'07',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'07',1,0))) d_7,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'08',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'08',1,0))) d_8,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'09',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'09',1,0))) d_9,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'10',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'10',1,0))) d_10,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'11',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'11',1,0))) d_11,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'12',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'12',1,0))) d_12,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'13',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'13',1,0))) d_13,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'14',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'14',1,0))) d_14,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'15',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'15',1,0))) d_15,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'16',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'16',1,0))) d_16,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'17',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'17',1,0))) d_17,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'18',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'18',1,0))) d_18,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'19',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'19',1,0))) d_19,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'20',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'20',1,0))) d_20,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'21',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'21',1,0))) d_21,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'22',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'22',1,0))) d_22,
        decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'23',1,0)),0,'-',sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'23',1,0))) d_23,
count(*)            total
from
        v$log_history where first_time> sysdate-60
group by
        substr(to_char(FIRST_TIME,'YYYY/MM/DD,DY'),1,15)
order by
        substr(to_char(FIRST_TIME,'YYYY/MM/DD,DY'),1,15) desc;

----2

SELECT  to_char(first_time,'yyyy-mm-dd') Dt,  
to_char(first_time, 'Dy') dy,  
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  
group by to_char(first_time,'yyyy-mm-dd') ,  
to_char(first_time, 'Dy')  
order by 1;

最新文章

1. Windows Server 2008 R2 下配置证书服务器和HTTPS方式访问网站
2. android:theme决定AlertDialog的背景颜色
3. akka优势
4. C# basic
5. UITextField限制中英文字数和光标定位以及第三方输入限制问题
6. js处理日期的一些整理(js获取给定日期前一天的日期)
7. ShellExecute的各种用法
8. 李洪强漫谈iOS开发[C语言-014]-变量
9. websocket 通信协议
10. java 枚举类型和数据二进制等问题思考
11. NOIP 2015
12. CVS简单介绍
13. opencv源码学习： getStructuringElement函数;
14. Jmeter的Body Data里输入中文时乱码
15. NodeJS学习之win10安装与sublime配置
16. java.net.SocketException: Connection reset 硬件防火墙也有罪？
17. 【JEECG技术文档】Online唯一校验使用说明
18. Jmeter CSV Data Set Config参数化
19. 使用DbTableColumnWeb项目简要
20. 编程语言教程书该怎么写: 向K&R学习！

热门文章

1. Sample Means（耶鲁大学教材）
2. Manjaro使用笔记-使用中国源的方法
3. MySQL and Sql Server:Getting metadata using sql script (SQL-92 standard)
4. csharp: Configuring ASP.NET with Spring.NET and FluentNHibernate
5. 原生JS强大DOM选择器querySelector与querySelectorAll
6. 2018-01-17 Antlr4实现简单语言之整数比较表达式
7. 如何将web项目部署到Ubuntu服务器上
8. gulp使用 笔记
9. 我的Java之旅 第七课 JAVA WEB 会话管理
10. FreeSSHD login with permission denied