tailieunhanh - Tuning the Operating System

After completing this lesson, you should be able to do the following: Describe different system architectures Describe the primary steps of OS tuning Identify similarities between OS and DB tuning Understand virtual memory and paging Explain the difference between a process and a thread | Tuning the Operating System Objectives After completing this lesson, you should be able to do the following: Describe different system architectures Describe the primary steps of OS tuning Identify similarities between OS and DB tuning Understand virtual memory and paging Explain the difference between a process and a thread Operating System Tuning OS Memory SGA Oracle processes Non-Oracle processes OS and DB files Introduction to Operating System Tuning The system administrator, the person responsible for tuning the operating system (OS), has tuning concerns similar to those of the database administrator. But the system administrator is also concerned with how applications other than Oracle applications affect performance. When tuning, the system administrator considers: Memory usage I/O levels CPU usage Network traffic This lesson provides an overview of OS tuning, not specifics. This class focuses on OS tuning as it relates to the Oracle database rather than system performance . | Tuning the Operating System Objectives After completing this lesson, you should be able to do the following: Describe different system architectures Describe the primary steps of OS tuning Identify similarities between OS and DB tuning Understand virtual memory and paging Explain the difference between a process and a thread Operating System Tuning OS Memory SGA Oracle processes Non-Oracle processes OS and DB files Introduction to Operating System Tuning The system administrator, the person responsible for tuning the operating system (OS), has tuning concerns similar to those of the database administrator. But the system administrator is also concerned with how applications other than Oracle applications affect performance. When tuning, the system administrator considers: Memory usage I/O levels CPU usage Network traffic This lesson provides an overview of OS tuning, not specifics. This class focuses on OS tuning as it relates to the Oracle database rather than system performance tuning issues. The operating system is tuned in a specific order because each area has its effect on the other underlying areas. If the memory usage is too high for example, an extra load is placed on the I/O layer, which in turn places an extra load on the CPU. The correct tuning order is: 1. Memory 2. I/O 3. CPU System Architectures The Oracle database can run on different system architectures. Some examples are: Uni Processor systems Symmetric multiprocessing systems (SMP) Massively parallel processing systems (MPP) Clustered systems Nonuniform memory architecture systems (NUMA) System Architectures Uni Processor Systems Uni Processor systems have only one CPU and one memory. Symmetric Multiprocessing (SMP) Systems SMP systems have multiple CPUs. The number commonly ranges from two to 64. All of the CPUs in an SMP machine share the same memory, system bus, and I/O system. A single copy of the operating system controls all of the CPUs. Massively Parallel Processing (MPP) Systems MPP .