Oracle 11G redo日志组大小调整及日志频率检查

最新推荐文章于 2025-01-04 17:45:59 发布

原创

最新推荐文章于 2025-01-04 17:45:59 发布 · 1.7k 阅读

0 ·

CC 4.0 BY-SA版权

1.日志切换频率查询
SET LINE 150 PAGES 9999
COL "00" FOR A3
COL "01" FOR A3
COL "02" FOR A3
COL "03" FOR A3
COL "04" FOR A3
COL "05" FOR A3
COL "06" FOR A3
COL "07" FOR A3
COL "08" FOR A3
COL "09" FOR A3
COL "10" FOR A3
COL "11" FOR A3
COL "12" FOR A3
COL "13" FOR A3
COL "14" FOR A3
COL "15" FOR A3
COL "16" FOR A3
COL "17" FOR A3
COL "18" FOR A3
COL "19" FOR A3
COL "20" FOR A3
COL "21" FOR A3
COL "22" FOR A3
COL "23" FOR A3
COL DAY FOR A15
SELECT DAY,
     TO_CHAR(SUM(DECODE(H, '00', T, 0))) AS "00",
     TO_CHAR(SUM(DECODE(H, '01', T, 0))) AS "01",
     TO_CHAR(SUM(DECODE(H, '02', T, 0))) AS "02",
     TO_CHAR(SUM(DECODE(H, '03', T, 0))) AS "03",
     TO_CHAR(SUM(DECODE(H, '04', T, 0))) AS "04",
     TO_CHAR(SUM(DECODE(H, '05', T, 0))) AS "05"