When installing Oracle, you need to adjust the kernel parameters of Linux , but what do the parameters mean?Minimum values given in the Linux installation documentation:FS.AIO-MAX-NR = 1048576Fs.file-max = 6815744Kernel.shmall = 2097152Kernel.shmmax
During the operation, the Oracle Runtime CPU utilization reached more than 90%, and the following parameter values were adjusted to return to normal.Fs.file-max =
When installing the Oracle database, Oralce needs to set the following system kernel parameters, which are described below (the parameter values are kept in the etcsysctl file ).
When installing the Oracle database, Oralce needs to set the following
Memory Sharing notes:1. It allows two unrelated processes to access the same logical memory. (The memory is shared)2. It does not provide a synchronization mechanism, so we need to use other synchronization methods to achieve the synchronization
How to Set kernel. shmmax in Linux
The following is an explanation of the Oracle document, http://download-west.oracle.com/doc...e.htm#sthref107
Shmmax available physical memory defines the maximum allowable size of one shared memory segment.
The
Linux interprocess communication-Using shared memory The following will explain another way of communicating between processes, using shared memory. First, what is shared memory as the name implies, shared memory is to allow two unrelated processes
OverviewShared memory is one of the simplest ways to communicate between processes. Shared memory consent two or many other processes to access the same piece of memory, as if the malloc () function returns a pointer to the same physical memory area
1. What is shared memory?Shared memory allows two unrelated processes to access the same logical memory. Shared memory is a very efficient way to share and pass data between two running processes. Memory that is shared between different processes is
To account for the environment, is the real-time production database host network. HP-UX 11.31+oracle 10.2.0.4.0 RAC cluster.Two machines outdoor rac,essdb3 and ESSDB4 two machines.Physical memory 128g,sga allocated 64G,PGA 5G. Morning found ESSDB4
Fs.file-max = 6815744--Represents the maximum number of file handles, indicating the number of files that can be opened on a Linux system.Fs.aio-max-nr = 1048576--This parameter restricts the concurrent outstanding requests and avoids the I/O
OverviewShared memory is one of the simplest ways to communicate between processes. Shared memory allows two or more processes to access the same piece of memory, as if the malloc () function returns a pointer to the same physical memory area to a
Sql> Conn/as SYSDBAConnected to a idle instance.Sql> StartupOracle instance started.
Total System Global area 276824064 bytesFixed Size 778736 bytesVariable Size 137371152 bytesDatabase buffers 138412032 bytesRedo buffers 262144
The following error occurred while you were in the startup database today:Sql> Conn/as SYSDBAConnected to a idle instance.Sql> StartupORACLE instance started.Total System Global area 276824064 bytesFixed Size 778736 bytesVariable Size 137371152
Transferred from http://blog.csdn.net/robertkun/article/details/8518576
1. Methods of shared memoryUnix:qsharedmemory "owns" the Shared memory segment. When the "last thread or process" has an instance of qsharedmemory attached to a particular
Oracle
First, the preparation before installation
1, the task performed by root (log in with root user)
1.1 Setting System Variables
1 using a text editor to open the "/etc/system" file
# Vi/etc/system
2 Insert the following lines at the end of
Tag: ora-01081: "Cannot start already-running Oracle-shut it down first" applies to: oracle server - enterprise edition - version: 8.1.7.4 to 11.2.0.2.0 - Release: 8.1.7 to 11.2Generic UNIX when checking for Oracle instance background process
Article Title: how to set LINUX shared memory. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.
We can modify
/*** All processes share the same piece of memory, which has the highest efficiency among various inter-process communication methods.* Accessing the shared memory area is as fast as accessing the memory area exclusive to the process, and does not
PrerequisitesShared memory: shared memory segment:A memory area can be read by different processes. Oracle uses it to form sga. Oracle uses the following three methods to create an sga zone:1. Use a single shared memory segment.2. Use multiple
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.