为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8.1
【操作系统】:Windows11
【CPU】:16+512
【问题描述】*:
2024-07-12 16:20:43.218 [INFO] database P0000017652 T0000000000000023348 checkpoint requested by CKPT_INTERVAL, rlog free space[536526848], used space[335872]
2024-07-12 16:20:43.218 [INFO] database P0000017652 T0000000000000010788 checkpoint begin, used_space[335872], free_space[536526848]...
2024-07-12 16:20:43.221 [INFO] database P0000017652 T0000000000000010788 ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2024-07-12 16:20:43.221 [INFO] database P0000017652 T0000000000000010788 ckpt2_log_adjust: ckpt_lsn(9758932), ckpt_fil(0), ckpt_off(55918592), cur_lsn(9759143), l_next_seq(120416), g_next_seq(120416), cur_free(56061952), total_space(536862720), used_space(143360), free_space(536719360), n_ep(1), db_open_id(6)
2024-07-12 16:20:43.221 [INFO] database P0000017652 T0000000000000010788 checkpoint end, 0 pages flushed, used_space[143360], free_space[536719360].
2024-07-12 16:22:34.137 [ERROR] database P0000017652 T0000000000000011384 mem_malloc_ex2(1048632) out of memory!, fail to allocate memory from OS. file: ..\mgr\sess4.c line: 2837
2024-07-12 16:22:34.139 [ERROR] database P0000017652 T0000000000000011384 mem_malloc_ex2(1048632) out of memory!, fail to allocate memory from OS. file: ..\mgr\sess4.c line: 2872
2024-07-12 16:22:34.140 [FATAL] database P0000017652 T0000000000000011384 [for dem]SYSTEM SHUTDOWN ABORT.
2024-07-12 16:22:34.141 [FATAL] database P0000017652 T0000000000000011384 _beginthreadex error in os_thread_create with errno 22
2024-07-12 16:22:34.141 [FATAL] database P0000017652 T0000000000000011384 code = -1, dm_sys_halt now!!!
2024-07-12 16:22:34.141 [INFO] database P0000017652 T0000000000000011384 total 2 rfil opened!
根据你的描述,可以判定是因为内存不足导致。解决方法如下:
1、增加物理内存。(简单粗暴)
2、查询视图V$SYSTEM_LARGE_MEM_SQLS、V$LARGE_MEM_SQLS获取占用内存大的SQL进行优化。
3、调整参数,比如降低BUFFER、SORT_BUF_GLOBAL_SIZE、MEMORY_POOL、MEMORY_TARGET、RECYCLEHJ_BUF_GLOBAL_SIZE等,有可能会降低数据库性能。
4、创建JOB,分析当前活动会话内存占用量,保存后,踢掉会话,降低数据库被杀掉的概率。
麻烦 帮忙解决一下