Oracle查看每小時日誌切換量指令碼

標籤：.com   日誌   rom   history   rip   first   很多   有意思   art   

--
-- 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/
這裡有很多有意思的指令碼。

Oracle查看每小時日誌切換量指令碼