Insufficient memory may give rise to a claim of memory. If the demand for memory components of active processes exceeds the available physical memory in the system starts paging system, the movement of active processes to disk to physical memory is loaded. Begin to deteriorate at this stage of implementation. Gradually, the memory decline, and processes to eliminate or control deficiency without crashing the system begins to change, to move the disk to the memory of all the processes to use to load it. Paging is usually a sign of the nominal effective memory bottlenecks. Some operating systems, paging systems essential if related, and memory buffer to hold the powerful UNIX file system. In addition, some differences between the operating system to normal activities are in the household. If the swap is exaggerated, then certainly not becomes a memory bottleneck. Ideally, the parties should be minimal and should not change very little or nothing. Much depends on the user awareness. This page is not an attack as the basis for a good job of site selection is often used to move the puck. Should be all the program did not have to be a memory, if it works, use only a portion of the program. Most programs spend most of their time running up to 70 percent share of about 15 percent of the code. Therefore, the situation is often performed without primary users. Performance begins something like paging. However, this deterioration can be barely noticeable. Due to the increasing demand for memory deterioration is greater, and the performance is to take a break. Regular exchange of information as a normal part of the house disturbs the operating system performance. Some processes that are inactive for a specified period of time can be changed in order to preserve the memory. But to overcome the operating system through a permutation to a very unusual memory loss, has a negative impact on the performance almost immediately. This is because all processes are written to disk; the result is often difficult, because all processes are written to disk. To minimize paging and exchange, to avoid, reduce the number of simultaneously active processes or add more memory. 24 * 7 databases for high availability, it is impossible to get downtime to have more memory to add the window. It is very difficult to develop the material for this type of database server. Therefore we must take care of the memory available on the Oracle database configuration memory and calculation of the expected number of sessions in the database. The best thing is to create a new database and the development of new applications. In this phase of the development of applications, it is necessary to justify the claim of the storage and server hardware manufacturing base is in direct production costs before. Otherwise, the Oracle Server environment has a direct bearing on the explanation of high-memory database. Gitesh Trivedi has 14+ years of experience and author of technical writing of Remote Oracle Support and also author of Oracle DBA Interview Questions with answers books.
Related Articles -
Memory contention, oracle tuning, oracle server tuning, performance tuning, oracle memory,
|