Oracle View Log switching volume per hour script

--
--Show The number of Redo Log switches Per Hour
--

SET PAUSE on
SET PAUSE ' Press Return to Continue '
SET PAGESIZE 60
SET linesize 300

SELECT to_char (first_time, ' yyyy-mm-dd ') Aday,
To_char (first_time, ' hh24 ') hour,
COUNT (*) Total
From V$log_history
WHERE Thread#=&enterthreadid
GROUP by To_char (first_time, ' yyyy-mm-dd '),
To_char (first_time, ' hh24 ')
ORDER by To_char (first_time, ' yyyy-mm-dd '),
To_char (first_time, ' hh24 ') ASC
/



Http://www.oracle-wiki.net/startsql
https://www.dba-scripts.com/
There are a lot of interesting scripts here.

Oracle View Log switching volume per hour script