oracle如何查看日志切换,Oracle查看每小时日志切换量脚本

--

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

这里有很多有意思的脚本。

原文：http://www.cnblogs.com/Clark-cloud-database/p/7818303.html