oracle实用sql(1)--redolog归档频率

点击(此处)折叠或打开

1. SELECT trunc(first_time) "Date",
   
2.         to_char(first_time, 'Dy') "Day",
   
3.         count(1) "Total",
   
4.         SUM(decode(to_char(first_time, 'hh24'),'00',1,0)) "h0",
   
5.         SUM(decode(to_char(first_time, 'hh24'),'01',1,0)) "h1",
   
6.         SUM(decode(to_char(first_time, 'hh24'),'02',1,0)) "h2",
   
7.         SUM(decode(to_char(first_time, 'hh24'),'03',1,0)) "h3",
   
8.         SUM(decode(to_char(first_time, 'hh24'),'04',1,0)) "h4",
   
9.         SUM(decode(to_char(first_time, 'hh24'),'05',1,0)) "h5",
   
10.         SUM(decode(to_char(first_time, 'hh24'),'06',1,0)) "h6",
    
11.         SUM(decode(to_char(first_time, 'hh24'),'07',1,0)) "h7",
    
12.         SUM(decode(to_char(first_time, 'hh24'),'08',1,0)) "h8",
    
13.         SUM(decode(to_char(first_time, 'hh24'),'09',1,0)) "h9",
    
14.         SUM(decode(to_char(first_time, 'hh24'),'10',1,0)) "h10",
    
15.         SUM(decode(to_char(first_time, 'hh24'),'11',1,0)) "h11",
    
16.         SUM(decode(to_char(first_time, 'hh24'),'12',1,0)) "h12",
    
17.         SUM(decode(to_char(first_time, 'hh24'),'13',1,0)) "h13",
    
18.         SUM(decode(to_char(first_time, 'hh24'),'14',1,0)) "h14",
    
19.         SUM(decode(to_char(first_time, 'hh24'),'15',1,0)) "h15",
    
20.         SUM(decode(to_char(first_time, 'hh24'),'16',1,0)) "h16",
    
21.         SUM(decode(to_char(first_time, 'hh24'),'17',1,0)) "h17",
    
22.         SUM(decode(to_char(first_time, 'hh24'),'18',1,0)) "h18",
    
23.         SUM(decode(to_char(first_time, 'hh24'),'19',1,0)) "h19",
    
24.         SUM(decode(to_char(first_time, 'hh24'),'20',1,0)) "h20",
    
25.         SUM(decode(to_char(first_time, 'hh24'),'21',1,0)) "h21",
    
26.         SUM(decode(to_char(first_time, 'hh24'),'22',1,0)) "h22",
    
27.         SUM(decode(to_char(first_time, 'hh24'),'23',1,0)) "h23",
    
28.         decode(trunc(first_time),
    
29.                trunc(sysdate), round(count(1) / (24 * to_number(to_char(sysdate, 'sssss')+1) / 86400),2),
    
30.                round(count(1) / 24, 2)) "Avg"
    
31. FROM V$log_history
    
32. group by trunc(first_time), to_char(first_time, 'Dy')
    
33. Order by 1;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28539951/viewspace-2113727/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28539951/viewspace-2113727/