Oracle7 Server Tuning
CHAPTER
8
. Tuning Memory Allocation
T
his chapter discusses tuning memory allocation, specifically the following topics:
the importance of tuning memory
how to tune memory in general
tuning your operating system memory
tuning private SQL and PL/SQL areas
the shared pool
the buffer cache
reallocating memory
Proper sizing of these structures can greatly improve database performance. In this chapter, you will learn how to allocate memory to these structures to achieve best performance.
