oracle文档mysql文档_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"

Contents

Oracle

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

本文原创发布php中文网，转载请注明出处，感谢您的尊重！