oracle官方文档之和体系结构相关的文档



Oracle? Database Administrator's Guide 11 g Release 2 (11.2) E25494-05 Home Book List Contents Index Master Index Contact Us Previous Next PDF ·Mobi · ePub 6 Managing Memory In this chapter: About Memory Management Memory Architecture Ov

Oracle? Database Administrator's Guide 11g Release 2 (11.2) E25494-05

Home Book List Contents Index Master Index Contact Us

---

Previous Next

PDF ·Mobi · ePub

6 Managing Memory

In this chapter:

About Memory Management

Memory Architecture Overview

Using Automatic Memory Management

Configuring Memory Manually

Configuring Database Smart Flash Cache

Memory Management Reference

http://docs.oracle.com/cd/E11882_01/server.112/e25494/memory.htm#ADMIN00207

Oracle? Database Administrator's Guide 11g Release 2 (11.2) E25494-05

Home Book List Contents Index Master Index Contact Us

---

Previous Next

PDF ·Mobi · ePub

5 Managing Processes

In this chapter:

About Dedicated and Shared Server Processes

About Database Resident Connection Pooling

Configuring Oracle Database for Shared Server

Configuring Database Resident Connection Pooling

About Oracle Database Background Processes

Managing Processes for Parallel SQL Execution

Managing Processes for External Procedures

Terminating Sessions

Process and Session Data Dictionary Views

http://docs.oracle.com/cd/E11882_01/server.112/e25494/manproc.htm#ADMIN11000

Oracle? Database Performance Tuning Guide 11g Release 2 (11.2) E41573-03

Home Book List Contents Index Master Index Contact Us

---

Previous Next

PDF ·Mobi · ePub

7 Configuring and Using Memory

This chapter explains how to allocate memory to Oracle Database memory caches, and how to use those caches. Proper sizing and effective use of the Oracle Database memory caches greatly improves database performance. Oracle recommends using automatic memory management to manage the memory on your system. However, you can choose to manually adjust the memory pools on your system, as described in this chapter.

This chapter contains the following divs:

Understanding Memory Allocation Issues

Configuring and Using the Buffer Cache

Configuring and Using the Shared Pool and Large Pool

Configuring and Using the Redo Log Buffer

PGA Memory Management

Managing the Server and Client Result Caches

http://docs.oracle.com/cd/E11882_01/server.112/e41573/memory.htm#PFGRF014

Oracle? Database Concepts 10g Release 2 (10.2) B14220-02

Home Book List Contents Index Master Index Contact Us

---

Previous Next

PDF ·Mobi · ePub

8 Memory Architecture

This chapter discusses the memory architecture of an Oracle instance.

This chapter contains the following topics:

Introduction to Oracle Memory Structures

Overview of the System Global Area

Overview of the Program Global Areas

Dedicated and Shared Servers

Software Code Areas

http://docs.oracle.com/cd/B19306_01/server.102/b14220/memory.htm#i14490

http://docs.oracle.com/cd/E11882_01/server.112/e40540/memory.htm#i14490

Oracle? Database Concepts 10g Release 2 (10.2) B14220-02

Home Book List Contents Index Master Index Contact Us

---

Previous Next

PDF ·Mobi · ePub

9 Process Architecture

This chapter discusses the processes in an Oracle database system and the different configurations available for an Oracle system.

This chapter contains the following topics:

Introduction to Processes

Overview of User Processes

Overview of Oracle Processes

Shared Server Architecture

Dedicated Server Configuration

The Program Interface

http://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm#i16977

Oracle? Database Concepts 10g Release 2 (10.2) B14220-02

Home Book List Contents Index Master Index Contact Us

---

Previous Next

PDF ·Mobi · ePub

Part II

Oracle Database Architecture

Part II describes the basic structural architecture of the Oracle database, including physical and logical storage structures. Part II contains the following chapters:

Chapter 2, "Data Blocks, Extents, and Segments"

Chapter 3, "Tablespaces, Datafiles, and Control Files"

Chapter 4, "Transaction Management"

Chapter 5, "Schema Objects"

Chapter 6, "Dependencies Among Schema Objects"

Chapter 7, "The Data Dictionary"

Chapter 8, "Memory Architecture"

Chapter 9, "Process Architecture"

Chapter 10, "Application Architecture"

Chapter 11, "Oracle Utilities"

Chapter 12, "Database and Instance Startup and Shutdown"

ContentsOracle Database Performance Tuning Guide

Preface

What's New in Oracle Database Performance Tuning Guide?

Performance Tuning Overview

Designing and Developing for Performance

Performance Improvement Methods

Configuring a Database for Performance

Automatic Performance Statistics

Automatic Performance Diagnostics

Configuring and Using Memory

I/O Configuration and Design

Managing Operating System Resources

Instance Tuning Using Performance Views

The Query Optimizer

Using EXPLAIN PLAN

Managing Optimizer Statistics

Using Indexes and Clusters

Using SQL Plan Management

SQL Tuning Overview

Automatic SQL Tuning

SQL Access Advisor

Using Optimizer Hints

Using Plan Stability

Using Application Tracing Tools

Glossary