52 | Chapter 2: Oracle Architecture
Java pool
Provides memory allocation for Java objects and Java execution, including data
in the Java Virtual Machine in the database.
Streams pool
Provides memory allocation used to buffer Oracle Streams queued messages in
the SGA instead of in database tables and provides memory for capture and
apply.
Dynamic initialization parameters available for these pools include LARGE_POOL_
SIZE, JAVA_POOL_SIZE, and STREAMS_POOL_SIZE. These are automatically set
if MEMORY_TARGET or SGA_TARGET is specified.
Automatic PGA management
Oracle automatically manages the memory allocated to an instance Program Global
Area (PGA). The PGA consists of session memory and a private SQL area. The
memory amount can be controlled by setting the PGA_AGGREGATE_TARGET initialization
parameter. Automatic PGA management, available since Oracle Database
10g, greatly simplified management of SQL work areas and eliminated the need to
set several different initialization parameters that previously existed. As of Oracle
Database 11g, PGA memory allocation is automatically tuned along with the SGA
memory allocations by setting MEMORY_TARGET.
Pages:
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139