Tuning Memory Allocation

Tuning Memory Allocation - Tuning Memory Allocation...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Tuning Memory Allocation Important Terms: Block: A unit of data transfer between main memory and disk. Many blocks from one section of memory address space form a segment. Buffer: A main memory address in which the buffer manager caches currently and recently used data read from disk. Over time a buffer may hold different blocks. When a new block is needed, the buffer manager may discard an old block and replace it with a new one. Buffer pool: collection of buffers Cache or buffer cache: all buffers and buffer pools Segment: A segment is a set of extents allocated for a specific type of database object such as a table, index, or cluster. Solving Memory Allocation Problems Begin tuning memory allocation by tuning your operating system with these goals: Reduce Paging and swapping, fitting the system global area into main memory, allocating adequate memory to individual users. SHOW SGA- how much memory allocated to the SGA
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Tuning the Redo Log Buffer The LOG_BUFFER parameter reserves space for the redo log buffer that is fixed in size. LGWR always starts when the buffer begins to fill. For this reason, a larger buffer makes
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/25/2010 for the course MAT 443 taught by Professor Roberts during the Winter '10 term at University of Arizona- Tucson.

Page1 / 3

Tuning Memory Allocation - Tuning Memory Allocation...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online