- 论坛徽章:
- 0
|
http://www.hellodba.com/Doc/Oracle_Memory(1).htm
The SGA_TARGET initialization parameter reflects the total size of the SGA and
includes memory for the following components:
■ Fixed SGA and other internal allocations needed by the Oracle Database instance
■ The log buffer
■ The shared pool
■ The Java pool
■ The buffer cache
■ The keep and recycle buffer caches (if specified)
■ Nonstandard block size buffer caches (if specified)
■ The Streams pool
It is significant that SGA_TARGET includes the entire memory for the SGA, in contrast
to earlier releases in which memory for the internal and fixed SGA was added to the
sum of the configured SGA memory parameters. Thus, SGA_TARGET gives you precise
control over the size of the shared memory region allocated by the database. If
SGA_TARGET is set to a value greater than SGA_MAX_SIZE at startup, then the latter is
bumped up to accommodate SGA_TARGET. |
|