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 |
|
|
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 |
|
|
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
| Oracle? Database Performance Tuning Guide 11g Release 2 (11.2) E41573-03 |
|
|
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
| Oracle? Database Concepts 10g Release 2 (10.2) B14220-02 |
|
|
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 |
|
|
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
| Oracle? Database Concepts 10g Release 2 (10.2) B14220-02 |
|
|
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