Linux installation Oracle kernel parameter configuration instructions
Fs.file-max = 6815744
Represents the maximum number of file handles and the number of files that can be opened in the Linux system.
Fs.aio-max-nr = 1048576
-- this parameter limits the concurrency of outstanding requests and avoids the failure of the Istroke O subsystem. The recommended value is 104857610241024, that is, 1024K.
Kernel.shmall = 2097152
Represents the total amount of available shared memory in pages, which is equal to 4kB, or 4096 bytes, on a 32-bit system. The maximum size of a shared memory segment is 16G, so the number of pages that need to be shared memory is 16GB/4KB=16777216KB/4KB=4194304 (pages). That is, the physical memory of 16GB under 64Bit system. Set kernel.shmall = 4194304 to meet the requirement (almost double the original setting of 2097152). At this time, you can adjust the shmmax parameter to 16G, and modify SGA_MAX_SIZE and SGA_TARGET to 12G (the maximum size of SGA you want to set, of course, can also be 2G~14G, etc., and coordinate the use of PGA parameters and other memory such as OS, which cannot be set too full, such as 16G).
Kernel.shmmax = 2147483648
-- represents the maximum value of a single shared memory segment, in bytes. This value is usually half of physical memory, but it doesn't matter if it is larger. Here, it is set to 4GB, that is, [4294967296max 1024max 1024] = 4G. The shmmax setting should be large enough to accommodate the entire SGA under one shared memory segment, and a low setting may result in the need to create multiple shared memory segments, which may lead to system performance degradation.
Kernel.shmmni = 4096
-- represents the minimum value of a single shared memory segment, usually 4kB, or 4096bit.
Kernel.sem = 250 32000 100 128
-- 250 is the value of the parameter semmsl, indicating the maximum number of semaphores that can be contained in a semaphore set.
-- 32000 is the value of the parameter semmns, indicating the maximum number of semaphores allowed in the system.
-- 100 is the value of the parameter semopm, which represents the number of operations that a single semopm () call can perform on a semaphore set.
-128is the value of the parameter semmni, which represents the total set of system semaphores.
Net.ipv4.ip_local_port_range = 9000 65500
-- represents the range of the port.
Net.core.rmem_default = 262144
The default value (in bytes) that represents the size of the receive socket buffer.
Net.core.rmem_max = 4194304
-- represents the maximum receive socket buffer size (in bytes)
Net.core.wmem_default = 262144
The default value (in bytes) that represents the size of the send socket buffer.
Net.core.wmem_max = 1048576
Represents the maximum size of the send socket buffer in bytes.