Oracle Internals: An Introduction

Reference

This section contains a quick reference to the parameters, events, statistics, and APT scripts mentioned in Chapter 6.

Parameters

Parameter	Description
_LARGE_POOL_MIN_ALLOC	Large pool chunk allocations are rounded up to this size. This parameter defaults to 16K, and should not be changed.
_USE_ISM	Intimate shared memory is used by default where possible. However, the implementation is problematic on some operating systems, and so it is sometimes necessary to set this parameter to FALSE.
DB_BLOCK_BUFFERSDB_BLOCK_SIZE	The product of these two parameters dictates the size of the SGA area for the database block buffers.
DB_FILESLOG_FILES (prior to 8.1)CONTROL_FILES	These parameters affect the size of the fixed PGA. They should not be any larger than reasonably necessary.
LARGE_POOL_SIZE	Certain demands for large chunks of memory are satisfied from the large pool, if a large pool has been configured. This parameter sets the size of the large pool in bytes.
LOCK_SGA	If operating system paging is consistent, this parameter should be set to TRUE, to prevent the SGA from paging.
LOG_BUFFER	Although the log buffer has a separate area in the SGA, it should nevertheless be trivial in size.
OPEN_CURSORSOPEN_LINKSMAX_ENABLED_ROLES	These parameters affect the size of the fixed UGA. They should not be any larger than necessary.
PRE_PAGE_SGA	If set to TRUE, this causes all Oracle server processes to page in the entire SGA on process startup if necessary. This may yield ...