导航

< 2025年1月 >
29 30 31 1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31 1
2 3 4 5 6 7 8
统计
 

重做日志生成情况,一天生成日志大小: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');

posted on   slqt  阅读(255)  评论(0编辑  收藏  举报
 
点击右上角即可分享
微信分享提示