This module discussed how Oracle uses Sort Areas, shrinking and expanding them as necessary, depending on how much data there is to sort.
Now 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
- Name the contents of the PGA.
- Describe how Oracle uses memory for sorting
Click the link below to read about memory architecture definitions that were covered for the most significant points in this module.
Memory Architecture Definitions
In the next module, you will prepare to create your first database.