https://ittichaicham.com/wiki/index.php?action=history&feed=atom&title=Log_Switch_History_Matrix
Log Switch History Matrix - Revision history
2026-05-13T20:19:09Z
Revision history for this page on the wiki
MediaWiki 1.34.2
https://ittichaicham.com/wiki/index.php?title=Log_Switch_History_Matrix&diff=254&oldid=prev
Ittichai at 16:27, 13 March 2011
2011-03-13T16:27:04Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 16:27, 13 March 2011</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l69" >Line 69:</td>
<td colspan="2" class="diff-lineno">Line 69:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">== See Also ==</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* [[Calculate the size of archive log files each day]]</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Oracle_Scripts]]</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Oracle_Scripts]]</div></td></tr>
</table>
Ittichai
https://ittichaicham.com/wiki/index.php?title=Log_Switch_History_Matrix&diff=252&oldid=prev
Ittichai: Created page with "* The matrix of log switch history Reference: http://www.confio.com/English/Tips/Log_File_Switch_Completion.php <pre> SET lines 120 col "DAY(YYYY-MM-DD)" format A13 col "00" form..."
2011-03-13T16:24:49Z
<p>Created page with "* The matrix of log switch history Reference: http://www.confio.com/English/Tips/Log_File_Switch_Completion.php <pre> SET lines 120 col "DAY(YYYY-MM-DD)" format A13 col "00" form..."</p>
<p><b>New page</b></p><div>* The matrix of log switch history<br />
Reference: http://www.confio.com/English/Tips/Log_File_Switch_Completion.php<br />
<pre><br />
SET lines 120<br />
col "DAY(YYYY-MM-DD)" format A13<br />
col "00" format A3<br />
col "01" format A3<br />
col "02" format A3<br />
col "03" format A3<br />
col "04" format A3<br />
col "05" format A3<br />
col "06" format A3<br />
col "07" format A3<br />
col "08" format A3<br />
col "09" format A3<br />
col "10" format A3<br />
col "11" format A3<br />
col "12" format A3<br />
col "13" format A3<br />
col "14" format A3<br />
col "15" format A3<br />
col "16" format A3<br />
col "17" format A3<br />
col "18" format A3<br />
col "19" format A3<br />
col "20" format A3<br />
col "21" format A3<br />
col "22" format A3<br />
col "23" format A3<br />
<br />
SELECT to_char(first_time,'YYYY-MM-DD') "DAY(YYYY-MM-DD)",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'00',1,0)),'99') "00",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'01',1,0)),'99') "01",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'02',1,0)),'99') "02",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'03',1,0)),'99') "03",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'04',1,0)),'99') "04",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'05',1,0)),'99') "05",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'06',1,0)),'99') "06",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'07',1,0)),'99') "07",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'08',1,0)),'99') "08",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'09',1,0)),'99') "09",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'10',1,0)),'99') "10",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'11',1,0)),'99') "11",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'12',1,0)),'99') "12",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'13',1,0)),'99') "13",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'14',1,0)),'99') "14",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'15',1,0)),'99') "15",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'16',1,0)),'99') "16",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'17',1,0)),'99') "17",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'18',1,0)),'99') "18",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'19',1,0)),'99') "19",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'20',1,0)),'99') "20",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'21',1,0)),'99') "21",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'22',1,0)),'99') "22",<br />
to_char(sum(decode(to_char(first_time,'HH24'),'23',1,0)),'99') "23"<br />
FROM v$log_history group by to_char(first_time,'YYYY-MM-DD')<br />
ORDER BY "DAY(YYYY-MM-DD)";<br />
<br />
DAY(YYYY-MM-D 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23<br />
------------- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---<br />
2011-01-08 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0<br />
2011-01-09 0 0 0 0 0 0 0 0 4 5 0 0 0 0 0 3 4 0 1 7 3 11 1 1<br />
2011-01-10 1 0 0 0 0 0 0 0 4 7 16 0 2 2 9 14 7 0 4 7 7 10 2 11<br />
2011-01-11 7 0 4 0 1 8 9 7 9 12 6 21 3 7 8 15 0 6 9 10 9 0 13 8<br />
2011-01-12 8 0 1 7 11 13 0 4 0 23 8 13 2 9 10 14 0 3 5 13 2 6 9 22<br />
2011-01-13 0 8 10 4 8 1 2 0 14 17 10 0 0 7 8 15 12 0 16 8 9 16 6 14<br />
2011-01-14 11 1 8 18 6 9 6 15 0 7 18 14 0 7 18 27 0 1 11 7 12 6 8 16<br />
2011-01-15 10 9 8 19 6 9 6 10 9 18 6 12 12 11 6 13 6 9 9 0 6 15 16 12<br />
<br />
</pre><br />
[[Category:Oracle_Scripts]]</div>
Ittichai