DBA Daily SQL query Database health

SELECTSUBSTR (To_char (First_time,'MM/DD/RR HH:MI:SS'),1,5) Day,       SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),'xx',1,0)) H00,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' on',1,0)) H01,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' Geneva',1,0)) H02,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),'Geneva',1,0)) H03,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),'Geneva',1,0)) H04,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' to',1,0)) H05,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' .',1,0)) H06,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' -',1,0)) H07,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' ,',1,0)) H08,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' the',1,0)) H09,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),'Ten',1,0)) H10,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' One',1,0)) H11,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' A',1,0)) H12,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' -',1,0)) H13,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' -',1,0)) H14,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' the',1,0)) H15,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' -',1,0)) H16,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' -',1,0)) H17,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' -',1,0)) H18,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' +',1,0)) H19,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' -',1,0)) H20,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' +',1,0)) H21,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' A',1,0)) H22,SUM(DECODE (SUBSTR (To_char (First_time,'MM/DD/RR HH24:MI:SS'),Ten,2),' at',1,0)) H23,COUNT(*) Total fromV$log_history awhereFirst_time>=To_char (sysdate- One)GROUP  bySUBSTR (To_char (First_time,'MM/DD/RR HH:MI:SS'),1,5)ORDER  bySUBSTR (To_char (First_time,'MM/DD/RR HH:MI:SS'),1,5)DESC;

redo Log Switching frequency

DBA Daily SQL query Database health