欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

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

程序员文章站 2022-05-10 14:59:13
...

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
oracle官方文档之和体系结构相关的文档
Home
oracle官方文档之和体系结构相关的文档
Book List
oracle官方文档之和体系结构相关的文档
Contents
oracle官方文档之和体系结构相关的文档
Index
oracle官方文档之和体系结构相关的文档
Master Index
oracle官方文档之和体系结构相关的文档
Contact Us

oracle官方文档之和体系结构相关的文档
Previous
oracle官方文档之和体系结构相关的文档
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
oracle官方文档之和体系结构相关的文档
Home
oracle官方文档之和体系结构相关的文档
Book List
oracle官方文档之和体系结构相关的文档
Contents
oracle官方文档之和体系结构相关的文档
Index
oracle官方文档之和体系结构相关的文档
Master Index
oracle官方文档之和体系结构相关的文档
Contact Us

oracle官方文档之和体系结构相关的文档
Previous
oracle官方文档之和体系结构相关的文档
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
oracle官方文档之和体系结构相关的文档
Home
oracle官方文档之和体系结构相关的文档
Book List
oracle官方文档之和体系结构相关的文档
Contents
oracle官方文档之和体系结构相关的文档
Index
oracle官方文档之和体系结构相关的文档
Master Index
oracle官方文档之和体系结构相关的文档
Contact Us

oracle官方文档之和体系结构相关的文档
Previous
oracle官方文档之和体系结构相关的文档
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
oracle官方文档之和体系结构相关的文档
Home
oracle官方文档之和体系结构相关的文档
Book List
oracle官方文档之和体系结构相关的文档
Contents
oracle官方文档之和体系结构相关的文档
Index
oracle官方文档之和体系结构相关的文档
Master Index
oracle官方文档之和体系结构相关的文档
Contact Us

oracle官方文档之和体系结构相关的文档
Previous
oracle官方文档之和体系结构相关的文档
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
oracle官方文档之和体系结构相关的文档
Home
oracle官方文档之和体系结构相关的文档
Book List
oracle官方文档之和体系结构相关的文档
Contents
oracle官方文档之和体系结构相关的文档
Index
oracle官方文档之和体系结构相关的文档
Master Index
oracle官方文档之和体系结构相关的文档
Contact Us

oracle官方文档之和体系结构相关的文档
Previous
oracle官方文档之和体系结构相关的文档
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
oracle官方文档之和体系结构相关的文档
Home
oracle官方文档之和体系结构相关的文档
Book List
oracle官方文档之和体系结构相关的文档
Contents
oracle官方文档之和体系结构相关的文档
Index
oracle官方文档之和体系结构相关的文档
Master Index
oracle官方文档之和体系结构相关的文档
Contact Us

oracle官方文档之和体系结构相关的文档
Previous
oracle官方文档之和体系结构相关的文档
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官方文档之和体系结构相关的文档Oracle Database Performance Tuning Guide

  • oracle官方文档之和体系结构相关的文档Preface
  • oracle官方文档之和体系结构相关的文档What's New in Oracle Database Performance Tuning Guide?
  • oracle官方文档之和体系结构相关的文档Performance Tuning Overview
  • oracle官方文档之和体系结构相关的文档Designing and Developing for Performance
  • oracle官方文档之和体系结构相关的文档Performance Improvement Methods
  • oracle官方文档之和体系结构相关的文档Configuring a Database for Performance
  • oracle官方文档之和体系结构相关的文档Automatic Performance Statistics
  • oracle官方文档之和体系结构相关的文档Automatic Performance Diagnostics
  • oracle官方文档之和体系结构相关的文档Configuring and Using Memory
  • oracle官方文档之和体系结构相关的文档I/O Configuration and Design
  • oracle官方文档之和体系结构相关的文档Managing Operating System Resources
  • oracle官方文档之和体系结构相关的文档Instance Tuning Using Performance Views
  • oracle官方文档之和体系结构相关的文档The Query Optimizer
  • oracle官方文档之和体系结构相关的文档Using EXPLAIN PLAN
  • oracle官方文档之和体系结构相关的文档Managing Optimizer Statistics
  • oracle官方文档之和体系结构相关的文档Using Indexes and Clusters
  • oracle官方文档之和体系结构相关的文档Using SQL Plan Management
  • oracle官方文档之和体系结构相关的文档SQL Tuning Overview
  • oracle官方文档之和体系结构相关的文档Automatic SQL Tuning
  • oracle官方文档之和体系结构相关的文档SQL Access Advisor
  • oracle官方文档之和体系结构相关的文档Using Optimizer Hints
  • oracle官方文档之和体系结构相关的文档Using Plan Stability
  • oracle官方文档之和体系结构相关的文档Using Application Tracing Tools
  • oracle官方文档之和体系结构相关的文档Glossary