Now that you know about files and processes, it is time to learn about the last piece of the architecture puzzle, which is memory.
Oracle uses several memory structures: the
- System Global Area,
- Program Gobal Areas,
- and Sort Areas.
See Figure 1 below
Understanding and properly sizing the System Global Area, Program Global Areas, and Sort Areas can have big impact on overall database performance.
The System Global Area is the most significant structure, and the most important to understand. You've already seen, in the previous module, that it's divided into several smaller areas known as the database buffer cache,
the redo log buffer, and the shared pool. This module goes into more detail about each of those structures, particularly the shared pool.
When you are done with this module, you should be able to:
- Describe the memory structures that make up the SGA
- Describe how the database buffer cache manages data blocks
- Describe the purpose of the three types of buffer pools
- Describe the function of the redo log buffer.
- Identify the function of the large pool
- Describe how each session gets its own memory
- List the contents of the PGA
- Describe how Oracle uses memory for sorting
The knowledge that you gain in this lesson will enable you to understand many of the tuning issues that will arise when you manage an Oracle database.