重做日志生成情况,一天生成日志大小:select round(sum(blocks*block_size)/1024/1024/1024,2) BLOCK from v\$archived_log where completion_time<sysdate-1;
日志切换频率
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
SELECT sum(MINATES)/count(*) TIMES FROM (SELECT B.RECID,
B.FIRST_TIME,
A.FIRST_TIME LAST_TIME,
ROUND((A.FIRST_TIME - B.FIRST_TIME) * 24 * 60, 2) MINATES
FROM V\$LOG_HISTORY A, V\$LOG_HISTORY B
WHERE A.RECID = B.RECID + 1
ORDER BY A.FIRST_TIME DESC)
WHERE ROWNUM < 120;
非空闲等待事件:select count(sid) NUM from v\$session_wait where event not in (select name from v\$event_name where wait_class='Idle');
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步