In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-03-30 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
During database configuration, the limitations of sga generally come from three aspects:
1. Physical memory and available swap2. Kernel parameter SHMMAX3. Restrictions on shared memory for other operating systems
Usually, the configuration of kernel parameters will affect the configuration of some parameters in sga. The corresponding relationship between kernel parameters and init.ora is as follows:
Init.ora ParameterKernel Parameterdb_block_buffersshmmax, shmalldb_files (maxdatafiles)nfile, maxfileslarge_pool_sizeshmmax, shmalllog_buffershmmax, shmallprocessesnproc, semmsl, semmnsshared_pool_sizeshmmax, shmall
General parameter description:
maxfiles -soft file limit per process. maxuprc -Maximum number of concurrent user processes per user identity. nfile -The maximum number of files open systemwide at any given time. nproc -Maximum number of processes that can exist simultaneously in the system. shmall -This parameter sets the total number of shared memory pages available system-wide. Therefore, shmall should always be at least ceiling (shmmax / page_size). shmmax -Maximum size of a single shared memory segment in bytes. SHMMIN -Minimum size of a single shared memory segment in bytes. shmmni -Number of shared memory identifiers. shmseg -Maximum number of shared memory segments that a process can attach. semmns -Number of semaphores in the system. semmni -Number of semaphore set identifiers in the system; determines the number of semaphore sets that can be created at any time. semmsl -Maximum number of sempahore that can be contained in a semaphore set. It should be the same as the maximum number of Oracle processes.
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.