Kkjcre1p: unable to spawn jobq slave process Happened Intermittently When Memory_target Is Set and Swap Size Is Not Big (Doc ID 2356025.1) | To Bottom |
In this Document
APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.2.0.1 [Release 11.2 to 12.2]Information in this document applies to any platform. SYMPTOMSDatabase is running, and the processes which previously connected to database are working fine; however new sessions cannot be created with below symptom: SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 28 02:24:24 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. <============ sqlplus shows that it connects to an idle instance SQL> show parameter cpu ORA-01034: ORACLE not available Alert log shows that "Process J000 died, see its trace file" and "kkjcre1p: unable to spawn jobq slave process" at bad time frame. The problem happened intermittently. Memory_target is being used. Strace output shows that a mmap() OS system call failed, the mmap() is trying to "map"/"claim" it will use memory as big as SGA_MAX_SIZE/MEMORY_TARGET size, and OS returned error ENOMEM (Cannot allocate memory). [pid 16253] 15:38:39.787948 shmat(262149, 0, 0) = ?
[pid 16253] 15:38:39.787980 shmdt(0x7fd939905000) = 0 [pid 16253] 15:38:39.788011 mmap(0x66000000, 17079205888, PROT_READ|PROT_WRITE, MAP_SHARED|MAP_FIXED|MAP_ANONYMOUS, 0, 0) = -1 ENOMEM (Cannot allocate memory) <===== map 15GB memory [pid 16253] 15:38:39.788044 munmap(0x60000000, 33554432) = 0 [pid 16253] 15:38:39.788072 munmap(0x62000000, 33554432) = 0 [pid 16253] 15:38:39.788098 munmap(0x64000000, 33554432) = 0 However the free memory is more than 4GB. CAUSESwap size is under configured: When memory_target is configured, server process will try to mmap a memory as big as sga_max_size/memory_target when it is created. (It is not to allocate so much memory, but only to "claim" it could use so much memory in the future, given sga_max_size/memory_target is set). If free memory + free swap is smaller than sga_max_size/memory_target, operating system will fail with ENOMEM (Cannot allocate memory). So if swap size is under configured, the issue will be likely happened. SOLUTIONAdd more swap size (eg, 0.75 x memory size, ideally swap size should at least be equal to memory size) |
相关推荐
先使用1位的swap搭建4位的swap,再使用4位的swap模块和Logisim内置的comparator元件搭建排序电路(请不要使用Plexers类元件) 功能描述:该电路具有4个4位的二进制数字作为输入和4个4位的二进制数字作为输出。它的功能...
Swap DMA_TO_DEVICE and DMA_FROM_DEVICE.
color swapping of background and foreground
swapper_space is a fiction, retained to simplify the path through vmscan s shrink_page_list.
The DFM Programming Environment is one of the many unique concepts of the Genesis 2000 system. Unlike any existing tool, the DFM Programming Environment (DFMPE) enables any user with elementary ...
swap set page dirty for Embedded Linux.
swap.() returns a negative number if the corresponding feature is not available.
these includes are used for the fake swap support of dev drum.
信息安全_数据安全_Blockchain_Anchored_Swap_Meet_—a_mock_trial 信息保护 可信计算 数据泄露 应急响应 数据泄密
Misc. notes that may result in changes.
Linear Gradient Attributes Source Code for Linux.
Tell sys endian.h we have MD variants of the swap macros.
The C++ Standard Library A Tutorial and Reference (2nd Edition)+cppstdlib-code.zip C++标准库(第二版)英文版.pdf 非扫描版+源代码 Prefaceto the SecondEdition xxiii Acknowledgments for the Second...
either copy constructor or assignment operator.
大小字节转换, 包括从大小字节转换大小字节转换大小字节转换
1 Introduction...................................................................................................................................................6 2 Getting started.......................
prgen_scatter8_1.v dma_axi64_core0_top.v dma_axi64_core0.v dma_axi64_core0_wdt.v dma_axi64_core0_arbiter.v dma_axi64_core0_ctrl.v dma_axi64_core0_axim_wr.v dma_axi64_core0_axim_cmd.v dma_axi64...
/* This is the memory location we will return. It will * be set to 0 until we find something suitable */ void *memory_location; /* Initialize if we haven't already done so */ if(! has_...
1 Scope 1 2 Normative references 2 3 Terms and definitions 3 4 General principles 7 4.1 Implementation compliance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 4.2 Structure ...