https://www.hacks.be/wiki/index.php?action=history&feed=atom&title=Log_Switching_%2F_Archive_Logging Log Switching / Archive Logging - Revision history 2026-04-30T12:05:01Z Revision history for this page on the wiki MediaWiki 1.35.1 https://www.hacks.be/wiki/index.php?title=Log_Switching_/_Archive_Logging&diff=23&oldid=prev Tom: Created page with "=Log switch frequency map= <source lang="sql"> SELECT to_char(first_time,'YYYY-MM-DD') day , to_char(sum(decode(to_char(first_time,'HH24'),'00',1,0)),'999') "00" , t..." 2016-03-31T16:03:38Z <p>Created page with &quot;=Log switch frequency map= &lt;source lang=&quot;sql&quot;&gt; SELECT to_char(first_time,&#039;YYYY-MM-DD&#039;) day , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;00&#039;,1,0)),&#039;999&#039;) &quot;00&quot; , t...&quot;</p> <p><b>New page</b></p><div>=Log switch frequency map=<br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SELECT to_char(first_time,&#039;YYYY-MM-DD&#039;) day<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;00&#039;,1,0)),&#039;999&#039;) &quot;00&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;01&#039;,1,0)),&#039;999&#039;) &quot;01&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;02&#039;,1,0)),&#039;999&#039;) &quot;02&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;03&#039;,1,0)),&#039;999&#039;) &quot;03&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;04&#039;,1,0)),&#039;999&#039;) &quot;04&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;05&#039;,1,0)),&#039;999&#039;) &quot;05&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;06&#039;,1,0)),&#039;999&#039;) &quot;06&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;07&#039;,1,0)),&#039;999&#039;) &quot;07&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;08&#039;,1,0)),&#039;999&#039;) &quot;08&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;09&#039;,1,0)),&#039;999&#039;) &quot;09&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;10&#039;,1,0)),&#039;999&#039;) &quot;10&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;11&#039;,1,0)),&#039;999&#039;) &quot;11&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;12&#039;,1,0)),&#039;999&#039;) &quot;12&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;13&#039;,1,0)),&#039;999&#039;) &quot;13&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;14&#039;,1,0)),&#039;999&#039;) &quot;14&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;15&#039;,1,0)),&#039;999&#039;) &quot;15&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;16&#039;,1,0)),&#039;999&#039;) &quot;16&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;17&#039;,1,0)),&#039;999&#039;) &quot;17&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;18&#039;,1,0)),&#039;999&#039;) &quot;18&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;19&#039;,1,0)),&#039;999&#039;) &quot;19&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;20&#039;,1,0)),&#039;999&#039;) &quot;20&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;21&#039;,1,0)),&#039;999&#039;) &quot;21&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;22&#039;,1,0)),&#039;999&#039;) &quot;22&quot;<br /> , to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;23&#039;,1,0)),&#039;999&#039;) &quot;23&quot;<br /> FROM v$log_history<br /> GROUP BY to_char(first_time,&#039;YYYY-MM-DD&#039;)<br /> ORDER BY 1 desc;<br /> &lt;/source&gt;<br /> <br /> Same formatted for Jira copy/paste:<br /> &lt;source lang=&quot;sql&quot; class=&quot;mw-collapsible mw-collapsed&quot; style=&quot;width:700px&quot;&gt;<br /> SELECT &#039;|*&#039;<br /> || to_char(first_time,&#039;YYYY-MM-DD&#039;) || &#039;*|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;00&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;01&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;02&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;03&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;04&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;05&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;06&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;07&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;08&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;09&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;10&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;11&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;12&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;13&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;14&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;15&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;16&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;17&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;18&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;19&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;20&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;21&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;22&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> || to_char(sum(decode(to_char(first_time,&#039;HH24&#039;),&#039;23&#039;,1,0)),&#039;999&#039;) || &#039;|&#039;<br /> FROM v$log_history<br /> GROUP BY to_char(first_time,&#039;YYYY-MM-DD&#039;)<br /> ORDER BY 1 desc;<br /> &lt;/source&gt;</div> Tom