Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Linux installation Oracle kernel parameter configuration instructions

2025-04-10 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report