Oracle High Performance Tuning for 9i and 10g
This text covers the three parts of tuning an Oracle database: data modeling, SQL code tuning, and physical database configuration, and explains both problem detection and resolution.
TABLE OF CONTENTS Oracle High Performance Tuning for 9i and 10g
Chapter 12: Tuning Oracle Database File Structures
Overview
This chapter will examine the file structure layers of Oracle Database and the logical structures within the Oracle database controlling and utilizing the file structures. An Oracle database in its simplest form is made up of files stored in the file system of an operating system such as Unix, Linux, or Windows. The management, controlling and linking of all those files together is what is called the Oracle Instance. The Oracle Instance is effectively an instantiation on a server of the shared global area (the memory structures) and a number of processes.
12.1 Oracle Database Architecture and the Physical Layer
The architecture of an Oracle installation could be called the physical layer of Oracle Database. Architecturally Oracle Database is made up of an Oracle Instance and an Oracle database. The Instance contains the running Oracle binary software and the database contains the data for the Oracle Instance to access. As already stated the database itself is made of files resident in the file system of the operating system.
12.1.1 The Oracle Instance
The Oracle Instance is a part of Oracle Database sitting resident in memory when an Oracle database is active and available for use. That instance or instantiation of Oracle Database is made up of processes or programs and reserved memory buffer cache areas.
Figure 12.1: Oracle Instance Memory Cache Buffers
Buffers
Most of the aspects of tuning memory buffer cache areas are discussed in Chapter 15. The different buffers are shown in Figure 12.1.
Processes
Copyright Elsevier Inc. 2004 under license agreement with Books24x7
