Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
8
|
Oracle DBA Pocket Guide
cached, again using an LRU algorithm. The shared pool is
also used for caching information from the Oracle data dictio-
nary, which is the metadata that describes the structure and
content of the database itself.
Redo log buffer
The redo log buffer caches redo information in order to
improve performance. Oracle caches the information until it
can be written to the redo log on disk at a more optimal time,
which avoids the overhead of constantly writing to disk.
Large pool
The large pool is an optional area of the SGA used for buffer-
ing I/O for various server processes, including those used for
backup and recovery. The area is also used to store session
memory for the Shared Server (formerly known as the Multi-
Threaded Server, or MTS) and when using the XA protocol
for distributed transactions.
Files
Four types of files are used by the Oracle instance: control
files, datafiles, redo log files, and parameter files. When you
START the instance, the parameter file is read. When you
MOUNT the database, the control files are read. When you
OPEN the database, the datafiles and redo log files are refer-
enced. When a database is being updated, changes are
recorded in the online redo log files, which provide a mecha-
nism for recovery in case of a failure.
Parameter files
These files (either the INIT.ORA file or the SPFILE) specify
how the instance is configured and point to the control ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843