O'Reilly logo

Oracle Internals: An Introduction by Steve Adams

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required