--

-- 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

/