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

WBOY

Lepaskan： 2016-06-07 15:45:21

asal

1215 orang telah melayarinya

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

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

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

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

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

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

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: