First page Back Continue Last page Graphics
Summary
The major memory areas are:
- PGA
- System Global Area (SGA)
- Shared Pool
- Library Cache
- Dictionary Cache
- Buffer Cache
- Subcaches
- Keep and Recycle Caches
- Java pool
- Large pool
Size has performance impact
They are sized with parameters
Learn how to adjust in lesson Initialization Parameter Files
Notes:
So, now you have learned about database files, processes and memory areas. The size of memory areas have an impact on the performance of your database – in the lesson, Initialization Parameter Files, you will learn how to adjust these parameters. (Though you will need some more study – beyond this course – to learn how to tune your instance. a good starting point is chapter 22 of the Oracle9i Database Performance Tuning Guide and Reference.)