getarc_hh.sql 归档每小时
来源:互联网 发布:淘宝网时尚女装 编辑:程序博客网 时间:2024/05/01 11:57
--getarc_hh.sql查归档的每小时的总数
col "Total" for 9999
col "h0~h23" for a100SELECT to_char(first_time,'yyyy-mm-dd') "Date",
to_char(first_time, 'Dy') "Day",
count(1) "Total",
rpad(SUM(decode(to_char(first_time, 'hh24'),'00',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'01',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'02',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'03',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'04',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'05',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'06',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'07',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'08',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'09',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'10',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'11',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'12',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'13',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'14',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'15',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'16',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'17',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'18',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'19',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'20',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'21',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'22',1,0)),3,' ')||' '||
rpad(SUM(decode(to_char(first_time, 'hh24'),'23',1,0)),3,' ')
"h0~h23"
FROM V$log_history&dblink
group by to_char(first_time,'yyyy-mm-dd'), to_char(first_time, 'Dy')
Order by 1 desc;
效果如下:
--getarc.sql 查归档的总量和总数
SELECT trunc(SUM(BLOCKS *BLOCK_SIZE )/1024/1024/1024,2) AS "Size(G)",TRUNC(completion_time) archived_date FROM v$archived_log&&dblink GROUP BY TRUNC(completion_time) order by 2 desc;
select thread#,TRUNC(completion_time) archived_date,COUNT(*) from v$archived_log&&dblink GROUP BY thread#,TRUNC(completion_time) ORDER BY 2 DESC;
undef dblink
效果如下:
0 0
- getarc_hh.sql 归档每小时
- Oracle查询最近几天,每小时归档日志产生数量--脚本
- 分析slow-log 每小时慢sql情况
- 怎样用SQL语句算出每小时IP的访问数
- SQL语句统计每小时,每天、每月、每年的_数据
- Scripts:显示数据库中每小时每日的redo切换的脚本logswitchsize.sql
- Scripts:显示数据库每小时每日redo切换频率的脚本logswitchfreq.sql
- SQL存储过程——求每小时的99分位数
- 每小时自动生成一个SQL Server Profiler文件(Auto Generate an Hourly SQL Server Profiler Trace File)
- 归档
- 归档
- 归档
- 归档
- 归档
- 归档
- 归档
- 归档
- 归档
- blkid命令 获取文件系统类型、UUID
- VS自带代码混淆器DotFuscator的使用步骤
- iOS数据存储的四种方案对比
- std::vector介绍
- Android之仿心跳动画实现
- getarc_hh.sql 归档每小时
- Coins
- JPA JPQL 查询、排序
- js 点击切换图片
- yii的module中使用自己的Layout
- 重新上膛步枪
- exe4j 将jar包生成可执行文件 及注册码
- 求set uid ,set gid,sticky bit的三个权限的详细说明
- Spring原理学习