这篇博客展示了如何使用 SQL 查询统计 Oracle 数据库中 Redo 日志在最近一个月内的生成情况，具体到每个小时的数量，并且提供了查询最近一个月及特定月份的日志切换次数的方法，帮助了解数据库活动高峰期。
Oracle_redo_生存日志的计量
set heading on
set linesize 500
set pagesize 50
SELECT TO_CHAR (first_time, 'YYYY-MON-DD') day,
TO_CHAR (SUM (DECODE (TO_CHAR (first_time, 'HH24'), '00', 1, 0)),'99') "00",
TO_CHAR (SUM (DECODE (TO_CHAR (first_time, 'HH24'), '01', 1, 0)),'99') "01",
TO_CHAR (SUM (DECODE (TO_CHAR (first_time, 'HH24'), '02', 1, 0)),'99') "02",
TO_CHAR (SUM (DECODE (TO_CHAR (first_time, 'HH24'), '03', 1, 0)),'99') "03",
TO_CHAR (SUM (DECODE (TO_CHAR (first_time, 'HH24'), '04', 1, 0)),'99') "04",
TO_CHAR (SUM (DECODE (TO_CHAR (first_time, 'HH24'), '05', 1, 0)),'99') "05",
TO_CHAR (SUM (DECODE (T
set heading on
set linesize 500
set pagesize 50
SELECT TO_CHAR (first_time, 'YYYY-MON-DD') day,
TO_CHAR (SUM (DECODE (TO_CHAR (first_time, 'HH24'), '00', 1, 0)),'99') "00",
TO_CHAR (SUM (DECODE (TO_CHAR (first_time, 'HH24'), '01', 1, 0)),'99') "01",
TO_CHAR (SUM (DECODE (TO_CHAR (first_time, 'HH24'), '02', 1, 0)),'99') "02",
TO_CHAR (SUM (DECODE (TO_CHAR (first_time, 'HH24'), '03', 1, 0)),'99') "03",
TO_CHAR (SUM (DECODE (TO_CHAR (first_time, 'HH24'), '04', 1, 0)),'99') "04",
TO_CHAR (SUM (DECODE (TO_CHAR (first_time, 'HH24'), '05', 1, 0)),'99') "05",
TO_CHAR (SUM (DECODE (T
最低0.47元/天 解锁文章
1926
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
