Oracle工作总结日志文件切换频率的调整
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
O r a c l e工作总结日志文件切换频率的调整
Revised final draft November 26, 2020
日志文件大小问题解决方案报告
整体解决分两步走
目前修改建议:增大日志文件,同时增加日志组个数。
争取能达到业务高峰期3-5分钟切换一次。平均15-20分钟切一次。
第一步:
SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select * from(select,, last_time,round( minates
from v$log_history a,v$log_history b
where=+1
order by desc)where rownum<120
RECID FIRST_TIME LAST_TIME MINATES
11572 2010/11/8 20:44:20 2010/11/8 21:04:18
11571 2010/11/8 20:43:16 2010/11/8 20:44:20
11570 2010/11/8 18:47:18 2010/11/8 20:43:16
11569 2010/11/8 17:03:01 2010/11/8 18:47:18
11568 2010/11/8 16:59:12 2010/11/8 17:03:01
11567 2010/11/8 16:26:43 2010/11/8 16:59:12
11566 2010/11/8 15:39:18 2010/11/8 16:26:43
11565 2010/11/8 15:09:37 2010/11/8 15:39:18 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11564 2010/11/8 15:06:07 2010/11/8 15:09:37
11563 2010/11/8 15:05:55 2010/11/8 15:06:07
11562 2010/11/8 15:05:41 2010/11/8 15:05:55
11561 2010/11/8 15:05:28 2010/11/8 15:05:41
11560 2010/11/8 15:03:59 2010/11/8 15:05:28
11559 2010/11/8 14:52:44 2010/11/8 15:03:59
11558 2010/11/8 14:35:27 2010/11/8 14:52:44
11557 2010/11/8 14:21:47 2010/11/8 14:35:27
11556 2010/11/8 14:10:30 2010/11/8 14:21:47
11555 2010/11/8 14:00:58 2010/11/8 14:10:30
11554 2010/11/8 13:53:08 2010/11/8 14:00:58
11553 2010/11/8 13:26:04 2010/11/8 13:53:08
11552 2010/11/8 12:01:15 2010/11/8 13:26:04
11551 2010/11/8 11:23:40 2010/11/8 12:01:15
11550 2010/11/8 11:07:02 2010/11/8 11:23:40
#NO1 第一段 5分钟切换次数 5次 250M
11549 2010/11/8 11:06:20 2010/11/8 11:07:02
11548 2010/11/8 11:05:29 2010/11/8 11:06:20
11547 2010/11/8 11:04:46 2010/11/8 11:05:29
11546 2010/11/8 11:04:02 2010/11/8 11:04:46
11545 2010/11/8 11:03:16 2010/11/8 11:04:02
####################################################
11543 2010/11/8 11:00:49 2010/11/8 11:01:44
11542 2010/11/8 10:58:28 2010/11/8 11:00:49
11541 2010/11/8 10:51:54 2010/11/8 10:58:28
11540 2010/11/8 10:34:17 2010/11/8 10:51:54
11539 2010/11/8 10:08:00 2010/11/8 10:34:17
11538 2010/11/8 9:50:53 2010/11/8 10:08:00
11537 2010/11/8 9:37:23 2010/11/8 9:50:53
11536 2010/11/8 9:27:48 2010/11/8 9:37:23
11535 2010/11/8 9:14:02 2010/11/8 9:27:48
11534 2010/11/8 8:50:34 2010/11/8 9:14:02
11533 2010/11/8 8:15:57 2010/11/8 8:50:34
11532 2010/11/8 7:28:49 2010/11/8 8:15:57
11531 2010/11/8 7:28:42 2010/11/8 7:28:49 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11530 2010/11/8 4:30:51 2010/11/8 7:28:42
11529 2010/11/8 1:56:31 2010/11/8 4:30:51
11528 2010/11/7 22:14:14 2010/11/8 1:56:31
11527 2010/11/7 18:21:21 2010/11/7 22:14:14
11526 2010/11/7 16:05:22 2010/11/7 18:21:21
11525 2010/11/7 14:32:28 2010/11/7 16:05:22
11524 2010/11/7 13:47:08 2010/11/7 14:32:28 >>>>>>>>>>>>>>>>>>>>>>>>>> 段落2>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> # NO2 这一段最为频繁开始时间 13:47:08 截止时间 13:42分
#切换次数 12次 600M
11523 2010/11/7 13:46:11 2010/11/7 13:47:08
11522 2010/11/7 13:45:38 2010/11/7 13:46:11
11521 2010/11/7 13:45:11 2010/11/7 13:45:38
11520 2010/11/7 13:44:38 2010/11/7 13:45:11
11519 2010/11/7 13:44:16 2010/11/7 13:44:38
11518 2010/11/7 13:43:56 2010/11/7 13:44:16
11517 2010/11/7 13:43:34 2010/11/7 13:43:56
11516 2010/11/7 13:43:13 2010/11/7 13:43:34
11515 2010/11/7 13:42:52 2010/11/7 13:43:13
11514 2010/11/7 13:42:31 2010/11/7 13:42:52
11513 2010/11/7 13:42:07 2010/11/7 13:42:31
11512 2010/11/7 13:41:43 2010/11/7 13:42:07
###########################################################
#NO 3开始时间 13:41:43 截止时间 13:36分
#切换次数 11次 550M
11511 2010/11/7 13:41:19 2010/11/7 13:41:43
11510 2010/11/7 13:40:58 2010/11/7 13:41:19
11509 2010/11/7 13:40:34 2010/11/7 13:40:58
11508 2010/11/7 13:40:01 2010/11/7 13:40:34
11507 2010/11/7 13:39:25 2010/11/7 13:40:01