时间:2021-07-01 10:21:17 帮助过:19人阅读
--
-- 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查看每小时日志切换量脚本
标签:.com 日志 rom history rip first 很多 有意思 art