oracle 11g管理篇

6 Managing Memory

About Memory Management................................................................................................................. 6-1 Memory Architecture Overview............................................................................................................ 6-2 Using Automatic Memory Management............................................................................................. 6-3 About Automatic Memory Management....................................................................................... 6-4 Enabling Automatic Memory Management.................................................................................. 6-4 Monitoring and Tuning Automatic Memory Management........................................................ 6-6 Configuring Memory Manually............................................................................................................ 6-7 Using Automatic Shared Memory Management.......................................................................... 6-8 Using Manual Shared Memory Management.............................................................................6-14 Using Automatic PGA Memory Management...........................................................................6-19 Using Manual PGA Memory Management................................................................................6-20 Configuring Database Smart Flash Cache........................................................................................6-21 When to Configure the Flash Cache.............................................................................................6-21 Sizing the Flash Cache....................................................................................................................6-21 Tuning Memory for the Flash Cache............................................................................................6-22 Flash Cache Initialization Parameters..........................................................................................6-22 Flash Cache in an Oracle Real Applications Clusters Environment........................................6-23 Memory Management Reference.......................................................................................................6-23 Platforms That Support Automatic Memory Management......................................................6-23 Memory Management Data Dictionary Views...........................................................................6-23 7 Managing Users and Securing the Database

The Importance of Establishing a Security Policy for Your Database........................................... 7-1 Managing Users and Resources............................................................................................................. 7-1 Managing User Privileges and Roles................................................................................................... 7-2 Auditing Database Use........................................................................................................................... 7-2 Predefined User Accounts...................................................................................................................... 7-2 8 Monitoring Database Operations

Monitoring Errors and Alerts................................................................................................................. 8-1 Monitoring Errors with Trace Files and the Alert Log................................................................. 8-1 Monitoring Database Operations with Server-Generated Alerts............................................... 8-4 Monitoring Performance......................................................................................................................... 8-6 Monitoring Locks............................................................................................................................... 8-7 Monitoring Wait Events.................................................................................................................... 8-7 Performance Monitoring Data Dictionary Views.......................................................................... 8-7 9 Managing Diagnostic Data

About the Oracle Database Fault Diagnosability Infrastructure.................................................... 9-1 Fault Diagnosability Infrastructure Overview............................................................................... 9-1 About Incidents and Problems......................................................................................................... 9-3 Fault Diagnosability Infrastructure Components......................................................................... 9-5 Structure, Contents, and Location of the Automatic Diagnostic Repository............................ 9-7 Investigating, Reporting, and Resolving a Problem......................................................................9-11 Roadmap—Investigating, Reporting, and Resolving a Problem.............................................9-11 viii