q_scn_by_hour
查询每个小时内scn的最大值和增长量
WITH log_data
AS (
SELECT TO_CHAR(FIRST_TIME, 'yyyymmdd hh24') AS day_time
,MAX(FIRST_CHANGE#) AS max_scn#
FROM v$log_history
-- WHEREFIRST_TIME > TRUNC(SYSDATE - 7)
GROUP BY TO_CHAR(FIRST_TIME, 'yyyymmdd hh24')
)
SELECT day_time
,max_scn#
,max_scn# - LAG(max_scn#, 1, 0) OVER (
ORDER BY day_time
) AS scn_change
FROM log_data
ORDER BY day_time;
页:
[1]