It's under your control.

Initialization Parameter Files When you start the instance, an initialization parameter file is read. There are two types of parameter files: • Server parameter file: This is the preferred type of initialization parameter file. It is a binary file that can be written to and read by the database server and must not be edited manually. It resides in the server that the Oracle database is executing..

Chapter 8. Regular expression (정규 표현 식) Oracle Database 10g: Administration Workshop l - System Global Area (SGA) : Shared by all server and background processes - Program Global Area (PGA) : Private to each server and background process. There is one PGA for each process. The SGA includer the following data structure:• Database buffer cache: Caches blocks of data retrieved from the database Pin..