Home
Home
Customize
Customize
Help
Help
Contact us
Contact Us

Virtual Book about 'Rman'

Virtual books arrange search results into categories based on information type. Like a regular book, the introductory material comes first, followed by how-to instructions, examples, then reference material, and finally troubleshooting.

This type of search works best for broad subjects that you want to research in depth, such as "security". If a regular search only produces a few matches, that term is not suitable for a virtual book.


Tip: If you don't find what you want, try searching for 'Recovery Manager' instead.


Table of Contents: Virtual Book about 'Rman'

This virtual book brings together the most relevant topics about 'Rman'. The topics are grouped into these categories:
[Back to top]

Introductory Information about 'Rman'

This category includes definitions, overviews, concepts, restrictions, frequently asked questions, and explanations of how things work. This is where you should start if you are not familiar with this subject area.

Results in this section come from these books:

[ Next Section ]

2 Day DBA

About Performance Advisors

[ Previous Section | Next Section ]

Administrator's Guide

Performance Considerations of FORCE LOGGING Mode

[ Previous Section | Next Section ]

Concepts

Overview of Scalability and Performance Features

Performance and Storage Considerations

Dynamic Performance Tables

Performance Diagnostic and Troubleshooting

RMAN and User-Managed Backups

RMAN with Online Backups

Overview of RMAN and User-Managed Restore and Recovery

RMAN Restore and Recovery

Partitioning to Improve Performance

Superior Performance

The Performance Cost of Integrity Constraints

Performance

[ Previous Section | Next Section ]

Performance Tuning Guide

Performance Tuning Overview

Introduction to Performance Tuning

Performance Planning

Introduction to Performance Tuning Features and Tools

Performance Planning

Understanding Investment Options

Understanding Scalability

System Architecture

A Sample Decision Process for Performance Conceptual Modeling

Performance Considerations for Initial Instance Configuration

Performance Considerations for Shared Servers

Overview of Data Gathering

Overview of the Automatic Workload Repository

Introduction to Database Diagnostic Monitoring

Understanding Memory Allocation Issues

Understanding I/O

Understanding Operating System Resources

Understanding Operating System Performance Issues

Understanding CPU

SQL Tuning Overview

Introduction to SQL Tuning

Automatic SQL Tuning Overview

Choosing an Optimizer Goal

Understanding the Query Optimizer

Understanding Access Paths for the Query Optimizer

Understanding Joins

Understanding Statistics

Understanding Index Performance

Understanding Optimizer Hints

Overview of the SQL Access Advisor in the DBMS_ADVISOR Package

Understanding EXPLAIN PLAN

Understanding SQL Trace and TKPROF

Overview of Database Replay

Overview of SQL Performance Analyzer

[ Previous Section | Next Section ]

PL/SQL User's Guide and Reference

Guidelines for Avoiding PL/SQL Performance Problems

[ Previous Section | Next Section ]

Reference

About Dynamic Performance Views

[ Previous Section | Next Section ]

2 Day + Performance Tuning Guide

Getting Started

Introduction

About This Guide

Overview of the Automatic Database Diagnostic Monitor

Overview of Active Session History

[ Previous Section | Next Section ]

Application Developer's Guide - Large Objects

Performance Guidelines

LOB Performance Guidelines

Performance Guidelines for Small LOBs

General Performance Guidelines

Temporary LOB Performance Guidelines

Performance Considerations for SQL Semantics and LOBs

[ Previous Section | Next Section ]

Application Developer's Guide - Object-Relational Features

How Locators Improve the Performance of Nested Tables

Performance of Object Comparisons

Performance and Storage Considerations for Scoped REFs

Performance of Varrays Versus Nested Tables

[ Previous Section | Next Section ]

Backup and Recovery Advanced User's Guide

About the RMAN Environment

RMAN Session Architecture

How RMAN Compiles and Executes Commands

RMAN Backups Concepts

About RMAN Channels

About RMAN Backups

How RMAN Performs Control File Autobackups

How RMAN Responds to Backup Errors

RMAN Recovery Concepts

How RMAN Selects Backups for Use in Restore Operations

How RMAN Searches for Archived Redo Logs During Recovery

Understanding RMAN TSPITR

RMAN TSPITR Concepts

How TSPITR Works With an RMAN-Managed Auxiliary Instance

How RMAN Deletes Backup Records from the RMAN Repository

Features and Options Used to Tune RMAN Performance

How Checkpoints Affect Performance

Creating a Duplicate Database with RMAN: Overview

RMAN DUPLICATE DATABASE: Prerequisites and Restrictions

About Creating Transportable Tablespace Sets from Backup with RMAN

When to Use RMAN to Create Transportable Tablespace Sets

How RMAN Creates Transportable Tablespace Sets from Backup

Figure 14-1 RMAN Transportable Tablespace From Backup: Architecture

Limitations of RMAN TRANSPORT TABLESPACE Command

[ Previous Section | Next Section ]

Backup and Recovery Basics

Overview of Interacting With the RMAN Client

Overview of RMAN Backups

About RMAN Backup Formats: Image Copies and Backup Sets

About RMAN Full and Incremental Datafile Backups

Overview of Reporting on Backups and the RMAN Repository

About RMAN Reports Generated by the LIST Command

About Reports of RMAN Backups

Database Restore and Recovery with RMAN: Overview

About RMAN Crosschecks

About Allocating Multiple RMAN Channels for Maintenance Commands

How RMAN Crosschecks and Deletes on Multiple Channels

About Uncataloging RMAN Records

[ Previous Section | Next Section ]

Backup and Recovery Reference

About RMAN Commands

About RMAN Compatibility

[ Previous Section | Next Section ]

Data Guard Broker

Performance Considerations for Fast-Start Failover

[ Previous Section | Next Section ]

Data Guard Concepts and Administration

About Standby Database Preparation Using RMAN

Creating a Standby Database with RMAN: Overview

[ Previous Section | Next Section ]

Data Provider for .NET Developer's Guide

Performance Considerations Related to the InitialLOBFetchSize property

Best Practice Guidelines and Performance Considerations

[ Previous Section | Next Section ]

Data Warehousing Guide

Performance Considerations for Parallel Partition-Wise Joins

Performance Considerations with SQL Modeling

[ Previous Section | Next Section ]

Enterprise Manager Concepts

Assessing Database Performance

Figure 5-2 Database Performance Page

Using Other Performance Tools

Tracking Statistics to Improve Database Performance

Performance and Usage

Service Performance

End-User Performance Monitoring

End-User Performance Monitoring

Request Performance Diagnostics

Monitoring Performance

Using Performance Metrics

Figure 8-7 Monitoring the Performance of Your Deployed J2EE Applications

Diagnosing Performance Issues with Top Reports

Analyzing Historical Performance

Diagnosing Identity Management Performance and Availability Problems

Host Performance Page

Figure 9-2 Host Performance Page

Diagnosing Oracle Collaboration Suite Performance and Availability Problems

Diagnosing Identity Management Performance and Availability Problems

[ Previous Section | Next Section ]

Globalization Support Guide

Storage and Performance Considerations in the Database Character Set Scanner

Performance Considerations for the Database Character Set Scanner

[ Previous Section | Next Section ]

High Availability Best Practices

Figure 3-4 Overview of System Performance

[ Previous Section | Next Section ]

High Availability Overview

Business Performance, Budget and Growth Plans

[ Previous Section | Next Section ]

HTML DB User's Guide

About Tuning Performance

[ Previous Section | Next Section ]

HTTP Server mod_plsql User's Guide

PL/SQL Performance in Oracle HTTP Server - Overview

[ Previous Section | Next Section ]

Installation Guide for HP OpenVMS

Performance Considerations

[ Previous Section | Next Section ]

JDBC Developer's Guide and Reference

Standard versus Oracle Performance Enhancement APIs

[ Previous Section | Next Section ]

Label Security Administrator's Guide

Planning a Label Tag Strategy to Enhance Performance

[ Previous Section | Next Section ]

Net Services Administrator's Guide

Performance Considerations

[ Previous Section | Next Section ]

New Features Guide

Collection Operator Performance Improvements

Dynamic RMAN Channel Allocation for Backing Up and Recovering RAC Database

RMAN Backup Encryption

Enhanced RMAN Backup Job Views

Fine-Grained, Automated Tracking of SQL Apply Runtime Performance

Hardware Assisted Resilient Data (HARD) Compliant RMAN Backups

Temporary Datafiles Are Re-Created on RMAN Recovery

Real Application Clusters (RAC) Performance

Performance Monitoring for Large Clusters

Use RMAN Compression During Cloning

Oracle Streams Performance and Usability Improvements

Streams Performance

Improved Performance of Network Data Model

Performance and Scalability

Improved Large Object (LOB) Performance

LOB Access Statistics in Dynamic Performance Views

Performance Improvements for Loading LOBs

Other Performance Improvements

Improved Aggregation Performance

Database Performance Monitoring Enhancements in Enterprise Manager

Performance Graph Normalization in Enterprise Manager

Read Performance Statistics Directly From the System Global Area (SGA)

Enhanced Automatic Database Diagnostic Monitor (ADDM) Performance Analysis

Enhanced End-to-End Performance Monitoring

Performance Improvements

ODP.NET: Improved LOB Retrieval Performance and Functionality

[ Previous Section | Next Section ]

OLAP Application Developer's Guide

What is the performance of each distribution channel?

[ Previous Section | Next Section ]

Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide

Overview of Configuring RMAN for Oracle Real Application Clusters

[ Previous Section | Next Section ]

Oracle Objects for OLE Developer's Guide

Performance Considerations with LOB Read and Write

[ Previous Section | Next Section ]

Platform Guide for Microsoft Windows (32-Bit)

Understanding Oracle Database Performance Objects

[ Previous Section | Next Section ]

Platform Guide for Microsoft Windows Itanium (64-Bit)

Understanding Oracle Database Performance Objects

[ Previous Section | Next Section ]

Platform Guide for Microsoft Windows x64 (64-Bit)

Understanding Oracle Database Performance Objects

[ Previous Section | Next Section ]

Pro*C/C++ Programmer's Guide

What Causes Poor Performance?

How Can Performance Be Improved?

[ Previous Section | Next Section ]

Programmer's Guide to the Oracle Precompilers

What Causes Poor Performance?

How Can Performance be Improved?

[ Previous Section | Next Section ]

Real Application Testing User's Guide

Overview of SQL Performance Analyzer

[ Previous Section | Next Section ]

Secure Backup Administrator's Guide

How RMAN Accesses Oracle Secure Backup

About RMAN and Oracle Secure Backup Metadata

[ Previous Section | Next Section ]

Streams Advanced Queuing User's Guide and Reference

Persistent Messaging Performance Overview

[ Previous Section | Next Section ]

Text Application Developer's Guide

Frequently Asked Questions a About Query Performance

What is Query Performance?

Frequently Asked Questions About Indexing Performance

How can I improve index performance for creating local partitioned index?

[ Previous Section | Next Section ]

Text Reference

Performance Considerations

[ Previous Section | Next Section ]

Utilities

Performance Considerations for Direct Path Exports

[ Previous Section | Next Section ]

Vault Administrator's Guide

How Realms Affect Performance

How Rule Sets Affect Performance

How Command Rules Affect Performance

How Factors Affect Performance

How Secure Application Roles Affect Performance

[Next Section]

Glossary

dynamic performance views

global dynamic performance views (GV$)

Recovery Manager (RMAN)

Recovery Manager (RMAN)

Recovery Manager (RMAN)

Recovery Manager (RMAN)

RMAN

RMAN

RMAN repository


[Back to top]

Tasks Related to 'Rman'

This category includes how-to information, both detailed procedures and general usage information and guidelines. The tasks are listed alphabetically, with shortcut links that jump to places within the list. For example, if you want to find Creating, look for a link labeled CRE.

Shortcuts to Tasks

Accepting a SQL Profile

Accessing Oracle Counters for Windows Performance Monitor

Accessing Oracle Counters for Windows Performance Monitor

Accessing Oracle Counters for Windows Performance Monitor

Accessing Previous ADDM Results

Accessing TUNE_MVIEW Output Results

Adding and Removing Workload Filters

Adding Information About RMAN Backups to the Oracle Secure Backup Catalog

Adding SQL Statements to a Workload

Allocating Additional Memory for the Library Cache

Allocating Additional Memory to the Data Dictionary Cache

Altering a SQL Profile

Analyzing Historical Performance

Analyzing Performance Using GCS and GES Statistics

Analyzing Workload Capture

Appending Columns to an Index or Using Index-Organized Tables

Assessing Data Guard Performance

Assessing Database Performance

Assessing I/O for Blocks, not Rows

Avoiding Pitfalls in TKPROF Interpretation

Avoiding the Argument Trap

Avoiding the Read Consistency Trap

Avoiding the Schema Trap

Avoiding the Time Trap

Avoiding the Trigger Trap

Backing Up Archived Redo Logs with RMAN

Backing Up Backup Sets with RMAN

Backing Up Control Files with RMAN

Backing Up Database Files and Archived Logs with RMAN

Backing Up Databases Using RMAN

Backing Up Existing Image Copy Backups with RMAN

Backing Up Individual Datafiles and Datafile Copies with RMAN

Backing Up Individual Tablespaces with RMAN

Backing Up Server Parameter Files with RMAN

Caching Session Cursors

Calculating the Buffer Cache Hit Ratio

Canceling Tasks

Capturing a Database Workload

Capturing a Database Workload Using APIs

Capturing a Database Workload Using Enterprise Manager

Capturing the SQL Workload

Changing Load

Changing Retention Policy Status of RMAN Backups

Changing SQL Statements in Workloads

Checking I/O Management

Checking Memory Management

Checking Network Management

Checking Process Management

Checking RMAN Syntax at the Command Line: Example

Checking RMAN Syntax in Command Files: Example

Checking Syntax of RMAN Commands and Command Files: CHECKSYNTAX

Checking System Statistics in the V$SESSTAT View

Checking the Progress of the SQL Tuning Advisor

Checking the Status of a SQL Tuning Task

Choosing an Optimizer Goal

Choosing Between Multiple DBWR Processes and I/O Slaves

Choosing Columns and Expressions to Index

Choosing Composite Indexes

Choosing Data Block Size

Choosing Keys for Composite Indexes

Clearing Alerts

Compacting Indexes

Comparing a Baseline to Another Baseline or Pair of Snapshots

Comparing Two Pairs of Snapshots

Configuring a Database for Performance

Configuring an RMAN Preauthorization

Configuring an RMAN Preauthorization on Linux or UNIX During Installation

Configuring an RMAN Preauthorization on Windows During Installation

Configuring an RMAN Preauthorization Post-Installation

Configuring and Using the Buffer Cache

Configuring and Using the Redo Log Buffer

Configuring and Using the Shared Pool and Large Pool

Configuring Automatic PGA Memory

Configuring Backup Piece Names for RMAN Backups to a Media Manager

Configuring Backup Piece Sizes for RMAN Backups to a Media Manager

Configuring Channels for RMAN in Oracle Real Application Clusters

Configuring End-User Performance Monitoring

Configuring End-User Performance Monitoring Using Earlier Versions of Oracle Application Server Web Cache

Configuring End-User Performance Monitoring Using Oracle Application Server Web Cache

Configuring End-User Performance Monitoring Using Oracle HTTP Server Based on Apache 2.0 or Apache HTTP Server 2.0

Configuring End-User Performance Monitoring Using Standalone Oracle Application Server Web Cache

Configuring Media Management Software for RMAN Backups

Configuring OC4J for Request Performance Diagnostics

Configuring OC4J Tracing for Request Performance Data

Configuring OLAP_PAGE_POOL_SIZE

Configuring Oracle Application Server Web Cache for End-User Performance Monitoring

Configuring Oracle Counters for Windows Performance Monitor

Configuring Oracle Counters for Windows Performance Monitor

Configuring Oracle Counters for Windows Performance Monitor

Configuring Oracle Counters for Windows Performance Monitor

Configuring Oracle Counters for Windows Performance Monitor

Configuring Oracle Counters for Windows Performance Monitor

Configuring RMAN Access to the Oracle Secure Backup SBT Library

Configuring RMAN and Oracle Secure Backup

Configuring RMAN to Make Backups to a Media Manager

Configuring the Automatic Database Diagnostics Monitor

Configuring the Forms Server for End-User Performance Monitoring

Configuring the Reserved Pool

Configuring the Right System Architecture for Your Requirements

Configuring the RMAN Control File and SPFILE Autobackup Feature

Configuring the RMAN Environment for Disk and Tape Backups

Configuring the RMAN Environment: Advanced Topics

Configuring the RMAN Snapshot Control File Location

Configuring Undo Space

Connecting the RMAN Client to Databases

Connecting to an Auxiliary Database from the RMAN Prompt

Connecting to Databases with RMAN

Connecting to the Target Database and Recovery Catalog from the RMAN Prompt

Connecting to the Target Database from the RMAN Prompt

Considering Multiple Buffer Pools

Controlling Performance with the Degree of Parallelism

Controlling RMAN Behavior when Backup Window Ends with PARTIAL

Controlling the Access Path and Join Order with Hints

Controlling the Behavior of the Query Optimizer

Correlating Server Sessions with RMAN Channels

Creating a Baseline

Creating a Client-Side Initialization Parameter File (PFILE) with RMAN

Creating a Cursor Using a CursorManagerSpecification

Creating a Cursor Without a CursorManagerSpecification

Creating a Default Permanent Tablespace

Creating a Duplicate Database with RMAN: Overview

Creating a SQL Tuning Set

Creating a SQL Tuning Set

Creating a SQL Tuning Set: Filter Options

Creating a SQL Tuning Set: Load Method

Creating a SQL Tuning Set: Options

Creating a SQL Tuning Set: Schedule

Creating a SQL Tuning Task

Creating a Standby Database with RMAN: Overview

Creating a Transportable Tablespace Set with RMAN: Procedure

Creating and Maintaining Tables for Good Performance

Creating and Updating Duplicate Databases with RMAN

Creating Baselines

Creating Media Families for RMAN Backups

Creating Outlines

Creating Permanent Tablespaces - Automatic Segment-Space Management

Creating Permanent Tablespaces for OLAP Use

Creating Snapshots

Creating Snapshots

Creating Subsequent Tablespaces

Creating Tasks

Creating Templates

Creating Temporary Tablespaces

Creating the Standby Control File with RMAN

Creating Transportable Tablespace Sets from Backup with RMAN

Customizing PLAN_TABLE Output

Deciding Which Statements to Tune

Defining Filters for Actions

Defining Filters for Module ID

Defining Filters for Resource Consumption

Defining Filters for SQL Text

Defining Filters for Tables

Defining Filters for Users

Defining the Workload Filters

Defining Workload Contents

Deleting a Database with RMAN

Deleting a SQL Tuning Set

Deleting Expired RMAN Backups after CROSSCHECK

Deleting Obsolete RMAN Backups Based on Retention Policies

Deleting RMAN Backups

Deleting SQL Statements from a Workload

Deleting Tasks

Deploying New Applications

Designing and Developing for Performance

Detecting I/O Problems

Detecting Physical Block Corruption With RMAN BACKUP... VALIDATE

Determining an Effective Setting for Shared Server UGA Storage

Determining Performance Impact for Altering your SGA or PGA

Determining Stale Statistics

Determining Which Segments Have Many Buffers in the Pool

Developing Efficient SQL Statements

Diagnosing Database Performance Issues with ADDM

Diagnosing Identity Management Performance and Availability Problems

Diagnosing Identity Management Performance and Availability Problems

Diagnosing Oracle Collaboration Suite Performance and Availability Problems

Diagnosing Performance Issues with Top Reports

Diagnosing Performance Problems

Directing RMAN Output to a Log File

Displaying Current RMAN Configuration Settings: SHOW

Displaying Performance Statistics for Propagations that Receive Buffered Messages

Displaying Performance Statistics for Propagations that Send Buffered Messages

Displaying PLAN_TABLE Output

Displaying RMAN Job Information in Oracle Secure Backup

Displaying the Contents of a SQL Tuning Set

Displaying the Results of a SQL Tuning Task

Dropping a Baseline

Dropping a SQL Profile

Dropping a SQL Tuning Set

Dropping Snapshots

Editing the TKPROF Output SQL Script

Enabling and Controlling Query Optimizer Features

Enabling and Disabling for End to End Tracing

Enabling and Disabling Statistic Gathering for End to End Tracing

Enabling and Disabling Workload Capture

Enabling Automatic Statistics Gathering

Enabling End-User Performance Monitoring for Standalone Oracle Application Server Web Cache

Enabling End-User Performance Monitoring for Third-Party Application Servers

Enabling Plan Stability

Enabling Query Optimizer Features

Entering Commands at the RMAN Prompt

Entering RMAN Commands at the Command Prompt

Estimating Statistics with Dynamic Sampling

Estimating the Compression factor

Estimating Workloads

Evaluating Performance in Oracle Real Application Clusters Environments

Example 1: Using IN - Selective Filters in the Subquery

Example 2: Using EXISTS - Selective Predicate in the Parent

Executing a SQL Tuning Task

Executing Multiple RMAN Commands In Succession Through a Pipe: Example

Executing RMAN Commands In a Single Job Through a Pipe: Example

Exporting and Importing Statistics

Exporting AWR Data for Workload Capture

Extracting AWR Data

Extrapolating From a Similar System

Finding Locks and Lock Holders

Finding System CPU Utilization

Finding the Cost of an Index

Finding the Object Requiring I/O

Finding the SQL Statement executed by Sessions Waiting for I/O

Gathering Data on the SQL Identified

Gathering Database Statistics Using the Automatic Workload Repository

Gathering Noworkload Statistics

Gathering Statistics with DBMS_STATS Procedures

Gathering Workload Statistics

Generating a Workload Capture Report Using APIs

Generating a Workload Capture Report Using Enterprise Manager

Generating Active Session History Reports

Generating Automatic Workload Repository Reports

Generating Filenames for RMAN Backup Pieces

Generating Filenames for RMAN Image Copies

Generating Plans

Generating Recommendations

Generating SQL Scripts

Generating the TKPROF Output SQL Script

Getting Started

Getting the Best Performance Results

Handling Corrupt Datafile Blocks in RMAN Backup: MAXCORRUPT

Handling I/O Errors in RMAN Backup: NOT BACKED UP SINCE

Handling Missing Statistics

How to Tune PGA_AGGREGATE_TARGET

How to Use Dynamic Sampling to Improve Performance

Identifying Contention for Shared Servers

Identifying Contention Using the Dispatcher-Specific Views

Identifying High-Load SQL

Identifying High-Load SQL Statements

Identifying High-Load SQL Statements Using ADDM Findings

Identifying High-Load SQL Statements Using Top SQL

Identifying Resource-Intensive SQL

Identifying RMAN Return Codes

Identifying Statements for EXPLAIN PLAN

Implementing ADDM Recommendations

Implementing Backup Retention Policy with RMAN

Implementing Business Logic

Implementing the Application

Implementing the SQL Access Advisor Recommendations

Improving Aggregation Performance

Improving Incremental Backup Performance: Change Tracking

Improving LOB Read/Write Performance

Improving Microsoft Transaction Server Application Performance

Improving Multimedia Data INSERT Performance in Objects Containing LOBs

Improving Multimedia LOB Data Retrieval and Update Performance

Improving Performance

Improving Performance

Improving Performance of Dynamic SQL with Bind Variables

Improving Performance Through Bind Variables

Improving Reliability and Performance

Improving Reliability and Performance

Improving Reliability and Performance

Improving Reliability and Performance

Improving Reliability and Performance

Improving Reliability and Performance

Improving Reliability and Performance

Improving Reliability and Performance

Improving Reliability and Performance

Improving Reliability and Performance

Improving Reliability and Performance

Improving Reliability and Performance

Improving the Login Performance of the Console Home Page

Improving Transaction Performance

Increasing Memory Allocated to the Buffer Cache

Increasing Memory Allocation

Increasing Performance with Concurrent Conventional Path Loads

Increasing Reliability and Performance

Increasing Reliability and Performance

Increasing Reliability and Performance

Increasing Scrollable Cursor Performance

Indexing Data

Instantiating an Entire Database on Different Platforms Using RMAN

Instantiating an Entire Database on the Same Platform Using RMAN

Instantiating an Entire Database Using RMAN

Instantiating Objects in a Tablespace Using Transportable Tablespace or RMAN

Instantiating Objects Using Transportable Tablespace from Backup with RMAN

Instantiating the Database Using RMAN

Instantiating the Database Using the RMAN CONVERT DATABASE Command

Instantiating the Database Using the RMAN DUPLICATE Command

Interpreting and Using the Buffer Cache Advisory Statistics

Interpreting CPU Statistics

Interpreting Oracle Statistics

Interpreting RMAN Error Stacks

Interpreting RMAN Errors: Example

Interpreting RMAN Message Output

Interpreting Shared Pool Statistics

Interpreting Statistics

Interpreting the Automatic Database Diagnostics Monitor Findings

Interpreting the Resolution of Statistics

Interrupting Tasks

Issuing RMAN Commands

Keeping Large Objects to Prevent Aging

Limiting Memory Use for Each User Session by Setting PRIVATE_SGA

Limiting RMAN CROSSCHECK to a Backups Since a Specific Time

Linking Tasks and Workloads

Listing RMAN Backups, Archived Logs, and Database Incarnations

Loading a SQL Tuning Set

Loading Active SQL Statements Incrementally from the Cursor Cache

Loading AWR Data

Loading SQL Cache Workloads

Loading SQL Statements from a User-Defined Workload

Loading SQL Statements from AWR Snapshots

Loading SQL Statements from Preserved Snapshot Sets

Loading SQL Statements from the Cursor Cache

Loading User-Defined Workloads

Locking Statistics

Locking Statistics for a Table or Schema

Looking Beyond Execution Plans

Maintaining Connections

Maintaining Execution Plans Over Time

Maintaining Workloads

Making Backups with RMAN: Advanced Topics

Making Consistent and Inconsistent Backups with RMAN

Making Split Mirror Backups with RMAN

Making Whole Database Backups with RMAN

Managing a Completed Workload Capture

Managing Archived Redo Logs Using RMAN

Managing Archived Redo Logs Using RMAN in Oracle Real Application Clusters

Managing Backup Performance with MINIMIZE TIME and MINIMIZE LOAD

Managing Backup Windows and Performance: BACKUP... DURATION

Managing Baselines

Managing Data and Transactions

Managing Excessive I/O

Managing Optimizer Statistics

Managing RMAN Metadata in Oracle Secure Backup

Managing Snapshots

Managing Snapshots

Managing SQL Profiles

Managing SQL Tuning Sets

Managing Statistics

Managing Tasks

Managing the Automatic Workload Repository

Managing the RMAN Repository Using Only the Control File

Managing the User Interface

Managing User Requests and Resource Allocation

Managing Workloads

Marking Recommendations

Matching Server Sessions with Channels in Multiple RMAN Sessions

Matching Server Sessions with Channels When One RMAN Session Is Active

Maximizing Job Performance

Measuring Performance by Service Using the Automatic Workload Repository

Minimizing Throw-Away

Modifying a SQL Tuning Set

Modifying or Disabling Triggers and Constraints

Modifying Oracle Counters for Windows Performance Monitor Parameters

Modifying Oracle Counters for Windows Performance Monitor Parameters

Modifying Oracle Counters for Windows Performance Monitor Parameters

Modifying Recommendations

Modifying Snapshot Settings

Modifying Snapshot Settings

Monitoring an Active Workload Capture

Monitoring and Diagnosing Parallel Execution Performance

Monitoring Configuration Performance

Monitoring CPU Utilization

Monitoring Disk I/O Utilization

Monitoring Disk Performance

Monitoring Disk Performance

Monitoring Flashback Database Performance Impact

Monitoring Host Activity

Monitoring Instance Activity

Monitoring Memory Utilization

Monitoring Oracle RAC Database Performance

Monitoring Parallel Execution Performance with Dynamic Performance Views

Monitoring Performance

Monitoring Performance

Monitoring Performance Alerts

Monitoring Performance by Analyzing GCS and GES Statistics

Monitoring Performance in a Replication Environment

Monitoring Performance with Oracle Enterprise Manager

Monitoring Real-Time Database Performance

Monitoring RMAN Interaction with the Media Manager

Monitoring RMAN Job Performance

Monitoring RMAN Job Progress

Monitoring RMAN Through V$ Views

Monitoring Streams Performance Using AWR and Statspack

Monitoring the End-User Performance of Forms Applications

Monitoring the Performance of Redo Transport Services

Monitoring the Performance of the Automatic PGA Memory Management

Monitoring Top Actions

Monitoring Top Modules

Monitoring Top Services

Monitoring Top Sessions

Monitoring Top SQL

Monitoring User Activity

Monitoring Workload Capture Using Enterprise Manager

Monitoring Workload Capture Using Views

Moving from RBO to the Query Optimizer

Moving Outline Tables

Moving to a New Oracle Release under the Query Optimizer

Naming the Standby Database Datafiles When Using RMAN

Naming the Standby Database Log Files When Using RMAN

Nesting Nested Loops

Obtaining the Channel ID from the RMAN Output

Optimizing Data Access Paths

Optimizing Instance Performance

Optimizing Performance

Optimizing Performance by Enabling Static and Context Sensitive Policies

Optimizing Performance by Setting Prefetch Count

Optimizing Performance of Direct Path Loads

Optimizing Performance of Distributed Queries

Optimizing Performance of OCCI Applications

Optimizing PL/SQL Performance

Optimizing SQL Statements

Ordering Columns in an Index

Ordering Keys for Composite Indexes

Paging and Swapping

Partitioning to Improve Performance

Peeking of User-Defined Bind Variables

Performance Tuning a CTXXPATH Index: Synchronizing and Optimizing

Performing a Quick Tune

Performing Backups with RMAN and Oracle Secure Backup

Performing Basic RMAN TSPITR

Performing Block Media Recovery with RMAN

Performing Customized RMAN TSPITR with an RMAN-Managed Auxiliary Instance

Performing Fully Automated RMAN TSPITR

Performing Recovery with RMAN and Oracle Secure Backup

Performing RMAN TSPITR Using Your Own Auxiliary Instance

Persistent Configuration Settings: Controlling RMAN Behavior

Planning a Label Tag Strategy to Enhance Performance

Preparing RMAN Commands for TSPITR with Your Own Auxiliary Instance

Preparing the Database for Tuning

Preparing the RMAN DUPLICATE Auxiliary Instance: Basic Steps

Preparing to Use RMAN to Create a Standby Database

Preparing Your Own Auxiliary Instance for RMAN TSPITR

Presenting Performance Ratios Graphically

Querying the Output Table

Re-creating Indexes

Reading and Understanding Execution Plans

Reading EXPLAIN PLAN Output

Reclaiming Unused Space

Recognizing RMAN Error Message Stacks

Recovering from Permanent Media Failure Using a Control File Copy

Reducing Checkpoint Frequency to Optimize Runtime Performance

Reducing Contention for Dispatcher Processes

Reducing Memory Allocated to the Buffer Cache

Reducing Memory Allocation

Reducing Memory Use with Three-Tier Connections

Reducing Parse Calls with JDBC

Reducing Parse Calls with OCI

Reducing Parse Calls with Oracle Forms

Reducing Parse Calls with SQLJ

Reducing Parse Calls with the Oracle Precompilers

Removing a Link Between a Workload and a Task

Removing Workloads

Renaming Control Files in RMAN DUPLICATE DATABASE

Renaming Database Files in RMAN Duplicate Database

Renaming Datafiles in RMAN DUPLICATE DATABASE

Renaming Online Logs in RMAN DUPLICATE DATABASE

Renaming Tempfiles in RMAN DUPLICATE DATABASE

Resetting Workloads

Resolving Performance Degradation Over Time

Resolving Transient Performance Problems

Responding to Alerts

Responding to Performance Findings

Restarting and Optimizing RMAN Backups

Restarting the Database

Restoring Default RMAN Configuration Settings: CONFIGURE... CLEAR

Restoring Files with RMAN

Restoring Previous Versions of Statistics

Restoring Previous Versions of Statistics

Restoring Statistics Versus Importing or Exporting Statistics

Restructuring the Data

Restructuring the Indexes

Restructuring the SQL Statements

Reviewing Other Performance-Related Charts

Reviewing the Automatic Database Diagnostics Monitor Analysis

Reviewing the Execution Plan

Reviewing the SQL Access Advisor Recommendations

Reviewing the SQL Access Advisor Recommendations: Details

Reviewing the SQL Access Advisor Recommendations: Recommendations

Reviewing the SQL Access Advisor Recommendations: SQL Statements

Reviewing the SQL Access Advisor Recommendations: Summary

RMAN RESTORE: Restoring Lost Database Files from Backup

RMAN TRANSPORT TABLESPACE: Specifying Locations for Data Pump Files

Running Active Session History Reports

Running ADDM Using addmrpt.sql

Running ADDM using DBMS_ADVISOR APIs

Running EXPLAIN PLAN

Running RMAN Client on host_dup

Running RMAN from host_src

Running the ashrpt.sql Report

Running the ashrpti.sql Report

Running the Automatic Workload Repository Compare Periods Reports

Running the awrddrpi.sql Report

Running the awrddrpt.sql Report

Running the awrrpt.sql Report

Running the awrrpti.sql Report

Running the awrsqrpi.sql Report

Running the awrsqrpt.sql Report

Running the SQL Access Advisor

Running the SQL Access Advisor: Filter Options

Running the SQL Access Advisor: Initial Options

Running the SQL Access Advisor: Recommendation Options

Running the SQL Access Advisor: Schedule

Running the SQL Access Advisor: Workload Source

Scheduling and Switching

Selecting OC4J Targets for Request Performance Diagnostics

Sending RMAN Output Simultaneously to the Terminal and a Log File

Serializing within Indexes

Setting Globalization Support Environment Variables for RMAN

Setting Media Management Parameters in RMAN

Setting Metric Thresholds for Performance Alerts

Setting PGA_AGGREGATE_TARGET Initially

Setting Statistics

Setting the DAYS_TO_EXPIRE Parameter

Setting the DBIO_EXPECTED parameter

Setting the Level of Statistics Collection

Setting the STATISTICS_LEVEL parameter

Setting Up a Database for RMAN Backup

Setting Up a Flash Recovery Area for RMAN

Setting Up ADDM

Setting Up RMAN for Use with a Shared Server

Setting Up Tasks and Templates

Setting Up the Capture Directory

Setting Workload Attributes

Sizing and Maximizing the Performance of Oracle Enterprise Manager

Sizing Data

Sizing Redo Log Files

Sizing the Buffer Cache

Sizing the Log Buffer

Sizing the Shared Pool

Skipping Tablespaces in RMAN DUPLICATE DATABASE

Solving Operating System Problems

Specifying a Full Set of Hints

Specifying a Query Block in a Hint

Specifying Complex Index Hints

Specifying Different Tables for EXPLAIN PLAN

Specifying Global Table Hints

Specifying Hints

Specifying Image Copy or Backup Set Output for RMAN BACKUP to Disk

Specifying Memory for Sorting Data

Specifying Options Affecting Output of the RMAN BACKUP Command

Specifying Output Device Type for RMAN BACKUP

Specifying Output File Locations for RMAN BACKUP

Specifying Tags for RMAN BACKUP

Starting a Workload Capture

Starting and Exiting RMAN

Starting and Stopping End-User Performance Monitoring

Starting and Stopping End-User Performance Monitoring

Starting End-User Performance Monitoring

Starting New Operating System Processes

Starting RMAN Without Connecting to a Database

Starting the RMAN Client and Running a Stored Script

Step 1: Setting Initialization Parameters for Trace File Management

Step 2: Enabling the SQL Trace Facility

Step 3: Formatting Trace Files with TKPROF

Step 4: Interpreting TKPROF Output

Step 5: Storing SQL Trace Facility Statistics

Stopping a Workload Capture

Stopping an Active Workload Capture

Stopping the Recommendation Process

Storing Outlines

Terminating an RMAN Command

Terminating an RMAN Session That Is Hung in the Media Manager

Terminating an RMAN Session: Basic Steps

Tracing for Client Identifier

Tracing for Entire Instance or Database

Tracing for Service, Module, and Action

Tracing for Session

Tracking Oracle Services for Microsoft Transaction Server Performance

Tracking Statistics to Improve Database Performance

Transforming Queries

Transporting a SQL Tuning Set

Transporting a SQL Tuning Set

Transporting Automatic Workload Repository Data

Troubleshooting RMAN TRANSPORT TABLESPACE

Troubleshooting RMAN TRANSPORT TABLESPACE: Filename Conflicts

Troubleshooting RMAN TRANSPORT TABLESPACE: Insufficient Shared Pool

Troubleshooting RMAN TSPITR

Troubleshooting TSPITR: RMAN Cannot Identify Tablespaces with Undo Segments

Tuning a Specific Program

Tuning an Application / Reducing Load

Tuning and Performance

Tuning and Performance

Tuning and Performance in Oracle Ultra Search

Tuning Crawl Performance

Tuning File System Cache to Improve Caching Performance

Tuning Materialized Views for Fast Refresh and Query Rewrite

Tuning Microsoft Transaction Server Performance

Tuning mode

Tuning Options

Tuning Oracle-Managed Files

Tuning Performance

Tuning PGA_AGGREGATE_TARGET

Tuning PL/SQL Applications for Performance

Tuning Query Performance

Tuning RMAN Backup Performance: Procedure

Tuning Search Performance

Tuning SQL Statements

Tuning SQL Statements

Tuning SQL Statements Using the SQL Tuning Advisor

Tuning the Database Proactively

Tuning the Database Reactively

Tuning the Large Pool and Shared Pool for the Shared Server Architecture

Tuning the Logical Structure

Tuning to Achieve a Better Compression Ratio

Uncataloging RMAN Records

Understanding Access Paths for the Query Optimizer

Understanding CPU

Understanding EXPLAIN PLAN

Understanding I/O

Understanding Index Performance

Understanding Investment Options

Understanding Joins

Understanding Memory Allocation Issues

Understanding Operating System Performance Issues

Understanding Operating System Resources

Understanding Optimizer Hints

Understanding Oracle Database Performance Objects

Understanding Oracle Database Performance Objects

Understanding Oracle Database Performance Objects

Understanding Recursive Calls

Understanding RMAN TSPITR

Understanding Scalability

Understanding SQL Trace and TKPROF

Understanding Statistics

Understanding the Query Optimizer

Understanding the SQL Trace Facility

Understanding TKPROF

Updating Task Attributes

Updating the CursorManagerSpecification for a CursorManager

Upgrading with a Test System

Using a Different Index Type

Using a Hypothetical Workload

Using a User-Defined Workload

Using a Workload Capture Report

Using Active Session History Reports

Using Advisors to Optimize Database Performance

Using an Auxiliary Destination for Automated RMAN TSPITR

Using an Existing SQL Tuning Set

Using ANALYZE to Improve Oracle Label Security Performance

Using Application Tracing Tools

Using Automatic Workload Repository Views

Using Bitmap Indexes for Performance

Using Bitmap Join Indexes for Performance

Using BLASTN_COMPRESS to Improve Search Performance

Using Category Names for Stored Outlines

Using Clusters for Performance

Using Command Files with RMAN

Using Compressed Backupsets for RMAN Backup

Using CONFIGURE and SET to Control RMAN Backup Encryption

Using CROSSCHECK to Update the RMAN Repository

Using CURSOR_SPACE_FOR_TIME

Using DELETE FORCE With RMAN Backups

Using Domain Indexes for Performance

Using Enabled Novalidated Constraints

Using EXPLAIN PLAN

Using FORMAT with RMAN BACKUP AS COPY

Using Function-based Indexes for Performance

Using Hash Clusters for Performance

Using Hints with Plan Stability

Using Hints with Views

Using Hypothetical Workloads

Using Image Copies for Faster RMAN TSPITR Performance

Using Incremental Backups to Improve Backup Performance With Tape Bottlenecks

Using Index-Organized Tables for Performance

Using Indexes and Clusters

Using Indexes to Improve Performance of XPath-Based Functions

Using Multiple Buffer Pools

Using Multiple RMAN Channels for Maintenance Operations

Using Nonunique Indexes to Enforce Uniqueness

Using Open/Close as Bracketing Operations for Efficient Performance

Using Operating System Caches

Using Operating System Resource Managers

Using Optimizer Hints

Using Oracle Counters for Windows Performance Monitor

Using Oracle Counters for Windows Performance Monitor

Using Oracle Counters for Windows Performance Monitor

Using Oracle Counters for Windows Performance Monitor

Using Oracle Counters for Windows Performance Monitor

Using Oracle Counters for Windows Performance Monitor

Using Other Performance Tools

Using Partitioned Indexes for Performance

Using Performance Metrics

Using Performance Views in Oracle Real Application Clusters

Using Plan Stability

Using Plan Stability to Preserve Execution Plans

Using Plan Stability with Query Optimizer Upgrades

Using RMAN and Oracle Secure Backup in a Real Application Clusters Environment

Using RMAN CONVERT to Copy Files Between ASM and Non-ASM Storage

Using RMAN DUPLICATE DATABASE: Examples

Using RMAN DUPLICATE With CONFIGURE AUXNAME: Example

Using RMAN DUPLICATE with OMF and ASM

Using RMAN DUPLICATE With SET NEWNAME: Example

Using RMAN for Database Transport, Duplication and Migration

Using RMAN Incremental Backups to Refresh a Standby Database

Using RMAN Incremental Backups to Roll Forward a Physical Standby Database

Using RMAN or Enterprise Manager to Restore the Server Parameter File (SPFILE)

Using RMAN REPORT NEED BACKUP with Different Retention Policies

Using RMAN REPORT NEED BACKUP with Tablespaces and Datafiles

Using RMAN to Back Up and Restore Files

Using RMAN to Create Backups in Oracle Real Application Clusters

Using RMAN to Start Up and Shut Down Databases

Using RMAN to Validate Database Files

Using RMAN TRANSPORT TABLESPACE: Basic Scenario

Using RMAN with Command Files

Using RMAN-Created Image Copies

Using SET NEWNAME with RMAN DUPLICATE to OMF

Using SHARED_POOL_RESERVED_SIZE

Using SQL Access Advisor Constants

Using SQL Statements from the Cache

Using SQL Tuning Advisor APIs

Using Stored Outlines

Using Summary Advisor Oracle Database 9i Workloads

Using Supplied Packages to Manage Stored Outlines

Using Tags to Identify RMAN Backups

Using Templates

Using the Automatic Workload Repository Compare Periods Reports

Using the Buffer Cache Effectively

Using the Cluster Database Instance Performance Page

Using the Cluster Database Performance Page

Using the Cluster Database Performance Page

Using the Cluster Performance Page

Using the Heterogeneous Services Dynamic Performance Views

Using the Large Pool

Using the Oracle Performance Method

Using the RMAN CONVERT DATABASE Command

Using the RMAN LIST Command

Using the RMAN Pipe Interface

Using the Shared Pool Effectively

Using the SQL Access Advisor

Using the SQL Trace Facility and TKPROF

Using the trcsess Utility

Using V$DB_CACHE_ADVICE

Using V$SQL_PLAN Views

Using Views

Using Wait Event Statistics to Drill Down to Bottlenecks

Using Workloads

Validating Backups with RMAN

Validating RMAN Backups: VALIDATE and RESTORE VALIDATE

Validating the Restore of Datafiles from RMAN Backup

Verifying and Troubleshooting End-User Performance Monitoring

Verifying Optimizer Statistics

Viewing Activity by Wait Statistics and Activity by Time Statistics

Viewing Bitmap Indexes with EXPLAIN PLAN

Viewing Details of SQL Statements

Viewing Elapsed Time Breakdown Statistics

Viewing Enabled Traces for End to End Tracing

Viewing Gathered Statistics for End to End Application Tracing

Viewing General SQL Statistics

Viewing Histograms

Viewing Information About Dynamic Resize Operations

Viewing Other SQL Statistics

Viewing Outline Data

Viewing Parallel Execution with EXPLAIN PLAN

Viewing Parallel Queries with EXPLAIN PLAN

Viewing Partitioned Objects with EXPLAIN PLAN

Viewing Performance Analysis

Viewing Recommendations

Viewing Session Activity

Viewing Shared Cursors Statistics and Execution Statistics

Viewing Snapshot Statistics

Viewing SQL Execution Plan

Viewing SQL Statements by Wait Class

Viewing SQL Statistics

Viewing SQL Statistics Summary

Viewing SQL Tuning Information

Viewing Statistics

Visiting Data as Few Times as Possible

Working with Recommendations

Working with RMAN Stored Scripts in the Recovery Catalog

Writing Statements That Avoid Using Indexes

Writing Statements That Use Indexes


[Back to top]

Examples of 'Rman'

This category includes sample procedure and sample code, to illustrate how to perform tasks or use features.

Results in this section come from these books:

[ Next Section ]

Performance Tuning Guide

A Sample Decision Process for Performance Conceptual Modeling

Figure 21-1 Database Replay Architecture

[ Previous Section | Next Section ]

2 Day + Performance Tuning Guide

Figure 8-6 Top 10 SQL Comparison by Execution Time

Figure 8-7 Top 5 Segments Comparison by Logical Reads

[ Previous Section | Next Section ]

Backup and Recovery Advanced User's Guide

Figure 14-1 RMAN Transportable Tablespace From Backup: Architecture

[ Previous Section | Next Section ]

Enterprise Manager Concepts

Figure 5-2 Database Performance Page

Figure 8-7 Monitoring the Performance of Your Deployed J2EE Applications

Figure 9-2 Host Performance Page

[ Previous Section | Next Section ]

High Availability Best Practices

Figure 3-4 Overview of System Performance

[ Previous Section | Next Section ]

2 Day DBA

Figure 10-2 Performance Analysis on Home Page

Figure 10-6 Performance Analysis

[ Previous Section | Next Section ]

Performance Tuning Guide

An ADDM Example

Example 13-1 Using EXPLAIN PLAN

Example 13-10 Full Outer Join

Example 13-2 EXPLAIN PLAN Output

Example 13-3 Effects of Clustering Factor on Cost

Example 13-4 Index Range Scan

Example 13-5 Index Skip Scan

Example 13-6 Sample Table Scan

Example 13-7 Hash Joins

Example 13-8 Hash Join Outer Joins

Example 13-9 Outer Join to a Multitable View

Example 14-1 Viewing Height-Balanced Histogram Statistics

Example 14-2 Viewing Frequency Histogram Statistics

Example 16-1 Specifying a Full Set of Hints

Example 16-2 Using a Query Block in a Hint

Example 16-3 Using Global Hints Example

Example 16-4 Using Global Hints with NO_MERGE

Example 17-1 Creating a Workload

Example 17-2 Creating a Workload from a Template

Example 17-3 Optimizing the Defining Query for Fast Refresh

Example 17-4 Access IMPLEMENTATION Output Through USER_TUNE_MVIEW View

Example 17-5 Save IMPLEMENTATION Output in a Script File

Example 17-6 Enable Query Rewrite by Creating Multiple Materialized Views

Example 17-7 Access IMPLEMENTATION Output Through USER_TUNE_MVIEW View

Example 17-8 Save IMPLEMENTATION Output in a Script File

Example 17-9 Optimized Sub-Materialized View for Fast Refresh

Example 19-1 Looking for Throw-Away in an Explain Plan

Example 19-10 Partial Partition-Wise Join with Range Partition

Example 19-11 Partial Partition-Wise Join with Composite Partition

Example 19-12 Full Partition-Wise Join

Example 19-2 Creating a PLAN_TABLE

Example 19-3 Using EXPLAIN PLAN with the STATEMENT ID Clause

Example 19-4 Using EXPLAIN PLAN with the INTO Clause

Example 19-5 Statement to display the EXPLAIN PLAN

Example 19-6 EXPLAIN PLAN for Statement Id ex_plan1

Example 19-7 EXPLAIN PLAN for Statement Id ex_plan2

Example 19-8 Parallel Query Explain Plan

Example 19-9 EXPLAIN PLAN with Bitmap Indexes

Example 1: Using IN - Selective Filters in the Subquery

Example 2: Using EXISTS - Selective Predicate in the Parent

Example 6-1 Example ADDM Report

Example 6-2 Function for ADDM Analysis on a Pair of Snapshots

Example 6-3 Reporting ADDM Analysis on a Pair of Specific Snapshots

Example 7-1 Calculating the Buffer Cache Hit Ratio

Example 7-2 Initial Setting of PGA_AGGREGATE_TARGET

Example 7-3 Calculating Cache Hit Percentage

Example 7-4 Querying V$SQL_WORKAREA_HISTOGRAM: Non-empty Buckets

Example 7-5 Querying V$SQL_WORKAREA_HISTOGRAM: Percent Optimal

Example 7-6 Querying V$SQL_WORKAREA_ACTIVE

Example 7-7 Querying V$SQL_WORKAREA

Example 7-8 Querying V$PGA_TARGET_ADVICE

Example 7-9 Querying V$PGA_TARGET_ADVICE_HISTOGRAM

Example of Domain Indexes and EXPLAIN PLAN

Example: Find Latches Currently Waited For

Examples of Displaying Range and Hash Partitioning with EXPLAIN PLAN

Examples of Full Partition-wise Joins

Examples of INLIST ITERATOR and EXPLAIN PLAN

Examples of Partial Partition-wise Joins

Examples of Pruning Information with Composite Partitioned Objects

Examples of TKPROF Statement

Examples of Using the SQL Access Advisor

Figure 10-1 Scattered Read, Sequential Read, and Direct Path Read

Figure 12-1 SQL Tuning Advisor APIs

Figure 12-2 SQL Tuning Sets APIs

Figure 12-3 SQL Profiles APIs

Figure 13-1 Query Optimizer Components

Figure 13-2 Index Skip Scan Illustration

Figure 14-1 height-Balanced Histogram with Uniform Distribution

Figure 14-2 height-Balanced Histogram with Non-Uniform Distribution

Figure 17-1 Materialized Views and the SQL Access Advisor

Figure 17-2 SQL Access Advisor Flowchart

Figure 19-1 A Table Hierarchy

Figure 2-1 Workload Growth Curve

Figure 22-1 SQL Performance Analyzer Workflow

Figure 7-1 Physical I/O and Buffer Cache Size

Figure 7-2 Redo Log Buffer

Figure 7-3 Graphical Representation of V$PGA_TARGET_ADVICE

Figure 8-1 Distributing Redo Members Across Disks

Figure 9-1 Average Workload and Peak Workload

Nested Loop Example

Sample Output of trcsess

Sample Table Scans

Sample TKPROF Body

Sample TKPROF Header

Sample TKPROF Output

Sample TKPROF Output

Sample TKPROF Summary

Three Sample Configurations

TKPROF Example 1

TKPROF Example 2

[ Previous Section | Next Section ]

PL/SQL User's Guide and Reference

Example 11-1 Nesting a Query to Improve Performance

Figure 1-1 PL/SQL Boosts Performance

[ Previous Section | Next Section ]

2 Day + Performance Tuning Guide

Figure 11-1 Scheduling a SQL Access Advisor Task

Figure 2-1 DB Time in Overall User Response Time

Figure 2-2 DB Time in User Transaction

Figure 2-3 Active Session History

Figure 3-1 Diagnostic Summary

Figure 3-2 Automatic Database Diagnostic Monitor (ADDM) Page

Figure 3-3 Performance Analysis

Figure 4-1 Database Performance Page

Figure 4-10 Monitoring Top Actions

Figure 4-11 Monitoring Instance Activity

Figure 4-12 Monitoring Host Activity

Figure 4-13 Performance Summary

Figure 4-2 Monitoring User Activity

Figure 4-3 Active Sessions Working page

Figure 4-4 Monitoring Top SQL

Figure 4-5 Monitoring Top Sessions

Figure 4-6 Viewing Session Details

Figure 4-7 Monitoring Top Services

Figure 4-8 Viewing Service Details

Figure 4-9 Monitoring Top Modules

Figure 5-1 Responding to Alerts

Figure 6-1 Analyzing Current Database Performance

Figure 6-2 Analyzing Historical Database Performance

Figure 7-1 ASH Report Results

Figure 7-2 Top User Events

Figure 7-3 Top Event P1/P2/P3 Values

Figure 7-4 Top Service/Module

Figure 7-5 Top SQL Command Types

Figure 7-6 Top SQL Statements

Figure 7-7 Top Sessions

Figure 7-8 Activity Over Time

Figure 8-1 AWR Compare Periods Report

Figure 8-2 Snapshot Sets

Figure 8-3 Top 5 Timed Events

Figure 8-4 Wait Events

Figure 8-5 Time Model Statistics

Figure 9-1 Top Activity Page

Figure 9-2 Viewing SQL Statement By Wait Class

Figure 9-3 SQL Details Page

Figure 9-4 Viewing SQL Text

Figure 9-5 Viewing SQL Statistics

Figure 9-6 Viewing Session Activity

Figure 9-7 Viewing SQL Execution Plan

Figure 9-8 Viewing SQL Tuning Information

[ Previous Section | Next Section ]

Administrator's Reference for HP OpenVMS

rmanpipe.sql Demonstrations

[ Previous Section | Next Section ]

Backup and Recovery Advanced User's Guide

After Installation of Media Manager, RMAN Channel Allocation Fails: Scenario

Backup Fails Because RMAN Cannot Locate an Archived Log: Scenario

Duplication Fails with Multiple RMAN-06023 Errors: Scenario

Executing Multiple RMAN Commands In Succession Through a Pipe: Example

Executing RMAN Commands In a Single Job Through a Pipe: Example

Figure 3-1 Performing RMAN Media Recovery

Figure 3-2 Performing RMAN Media Recovery

Interpreting RMAN Errors: Example

RMAN Backup Examples

RMAN Denies Logon to Target Database: Scenario

RMAN Does Not Recognize Character Set Name: Scenario

RMAN DUPLICATE DATABASE at a Past Point in Time: Example

RMAN DUPLICATE DATABASE From ASM to ASM: Example

RMAN DUPLICATE DATABASE From File System to ASM: Example

RMAN Fails to Delete All Archived Logs: Scenario

RMAN Fails to Start RPC Call: Scenario

RMAN Restore and Recovery Examples

RMAN Troubleshooting Scenarios

Using RMAN DUPLICATE DATABASE: Examples

Using RMAN DUPLICATE With CONFIGURE AUXNAME: Example

Using RMAN DUPLICATE With SET NEWNAME: Example

Using RMAN TRANSPORT TABLESPACE: Basic Scenario

[ Previous Section | Next Section ]

Backup and Recovery Basics

Checking RMAN Syntax at the Command Line: Example

Checking RMAN Syntax in Command Files: Example

RMAN-Based Disk and Tape Backup Strategies: Scenarios

[ Previous Section | Next Section ]

Backup and Recovery Reference

RMAN Code Examples

RMAN Compatibility: Scenario

[ Previous Section | Next Section ]

Data Guard Broker

Figure 6-44 Performance Page

[ Previous Section | Next Section ]

Globalization Support Guide

Example 3-4 NLS_LANGUAGE=GERMAN

Example 3-6 NLS_LANGUAGE=AMERICAN, NLS_TERRITORY=GERMANY

Example 3-7 NLS_LANGUAGE=GERMAN, NLS_TERRITORY=GERMANY

Example 3-8 NLS_LANGUAGE=GERMAN, NLS_TERRITORY=AMERICA

Example 5-5 Monolingual German Sort

Example 5-6 Comparing a Monolingual German Sort to a Multilingual Sort

Example 9-1 Specifying a German Sort with the NLS_SORT Session Parameter

[ Previous Section | Next Section ]

OLAP Developer's Guide to the OLAP API

Example 9-9 Getting CursorSpecification Objects from a CursorManagerSpecification

[ Previous Section | Next Section ]

OLAP DML Reference

Example 26-17 Replacing NA Values Permanently

[ Previous Section | Next Section ]

Oracle C++ Call Interface Programmer's Guide

Example 2-1 How to Determine the Major Client Version and set Performance Features

[ Previous Section | Next Section ]

Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide

Figure 13-1 Cluster Database Performance Page

RMAN Archiving Configuration Scenarios

RMAN Backup Scenario for Non-Cluster File System Backups

RMAN Restore Scenarios for Oracle Real Application Clusters

[ Previous Section | Next Section ]

Pro*C/C++ Programmer's Guide

Figure 11-5 Performance Graph

Figure 11-6 Performance Graph Case 1

Figure 11-7 Performance Graph Case 2

Figure C-1 PL/SQL Boosts Performance

[ Previous Section | Next Section ]

Pro*COBOL Programmer's Guide

Figure C-1 PL/SQL Boosts Performance

[ Previous Section | Next Section ]

Programmer's Guide to the Oracle Precompilers

Figure C-1 PL/SQL Boosts Performance

[ Previous Section | Next Section ]

Real Application Testing User's Guide

Figure 2-1 SQL Performance Analyzer Workflow

[ Previous Section | Next Section ]

Secure Backup Administrator's Guide

Example 12-3 Cataloging an RMAN Backup Image

Example 6-3 Preauthorizing an Operating System User to Make RMAN SBT Backups

Figure 6-3 RMAN and the Oracle Secure Backup SBT Interface

Figure 6-6 Using RMAN and Oracle Secure Backup in a Real Application Clusters Environment

[ Previous Section | Next Section ]

Secure Backup Reference

Example 4-28 Cataloging an RMAN Backup Image

[ Previous Section | Next Section ]

SQL*Plus User's Guide and Reference

Example 8-4 Tracing Statements for Performance Statistics and Query Execution Path

[ Previous Section | Next Section ]

System Administration Guide for IBM z/OS on System z

Example RMAN Backup Script


[Back to top]

Detailed Reference Information on 'Rman'

This category includes syntax for associated statements, APIs, or commands.

Results in this section come from these books:

[ Next Section ]

PL/SQL User's Guide and Reference

Better Performance

Figure 1-1 PL/SQL Boosts Performance

Improved Performance

[ Previous Section | Next Section ]

Reference

Dynamic Performance (V$) Views

Dynamic Performance (V$) Views: V$NLS_PARAMETERS to V$XML_AUDIT_TRAIL

Dynamic Performance View Descriptions

Dynamic Performance Views

V$RMAN_BACKUP_JOB_DETAILS

V$RMAN_BACKUP_SUBJOB_DETAILS

V$RMAN_BACKUP_TYPE

V$RMAN_CONFIGURATION

V$RMAN_ENCRYPTION_ALGORITHMS

V$RMAN_OUTPUT

V$RMAN_STATUS

[ Previous Section | Next Section ]

Administrator's Reference for HP OpenVMS

Enhanced Oracle Performance

Oracle Performance Tuning Tools

RMAN Archiving Configuration

Support for Shared Libraries in RMAN

[ Previous Section | Next Section ]

Administrator's Reference for UNIX-Based Operating Systems

API Conformance

Performance and Tuning

Performance Toolbox

SQLGetData Performance

[ Previous Section | Next Section ]

Advanced Replication Management API Reference

Replication Dynamic Performance Views

[ Previous Section | Next Section ]

Backup and Recovery Reference

Deprecated RMAN Commands

Format of RMAN Commands

RC_RMAN_BACKUP_JOB_DETAILS

RC_RMAN_BACKUP_SUBJOB_DETAILS

RC_RMAN_BACKUP_TYPE

RC_RMAN_CONFIGURATION

RC_RMAN_OUTPUT

RC_RMAN_STATUS

RMAN Command Entries

RMAN Command Format, Syntax Diagrams and Notation

RMAN Commands

RMAN Compatibility

RMAN Compatibility Matrix

RMAN Reserved Words

RMAN Text Conventions

Summary of RMAN Commands

Summary of RMAN Recovery Catalog Views

[ Previous Section | Next Section ]

Enterprise Manager Framework, Host, and Services Metric Reference Manual

Job Dispatcher Performance

Notification Method Performance

Notification Performance

Repository Collections Performance

[ Previous Section | Next Section ]

Enterprise Manager Oracle Database and Database-Related Metric Reference Manual

Cluster Disk Group Performance

Cluster Disk Performance

Data Guard Performance

Data Guard Performance

Instance Disk Group Performance

Instance Disk Performance

Single Instance Disk Group Performance

[ Previous Section | Next Section ]

Enterprise Manager Policy Reference Manual

Default Permanent Tablespace Set to a System Tablespace

Default Permanent Tablespace Set to a System Tablespace

Users with Permanent Tablespace as Temporary Tablespace

Users with Permanent Tablespace as Temporary Tablespace

WebLogic Performance Pack Enabled

[ Previous Section | Next Section ]

Enterprise Manager SNMP Support Reference Guide

Most Useful Database Instance Performance Ratios

[ Previous Section | Next Section ]

JDBC Developer's Guide and Reference

Additional Oracle Performance Extensions

ARRAY Performance Extension Methods

Performance Enhancements

Performance Extensions

Performance Optimization

Properties for Oracle Performance Extensions

[ Previous Section | Next Section ]

OLAP Java API Reference (Javadoc)

addCursorManagerUpdateListener

Class BaseCursorManager

Class CursorManagerSpecification

Class CursorManagerUpdateEvent

Class ExpressDataCursorManager

Class ExpressSpecifiedCursorManager

Class ExpressSQLCursorManager

createCursorManager

createCursorManager

createCursorManager

createCursorManager

createCursorManager

createCursorManagers

createCursorManagers

createCursorManagers

createCursorManagers

createCursorManagerSpecification

createSQLCursorManager

createSQLCursorManagers

createSQLCursorManagers

createSQLCursorManagers

createSQLCursorManagers

cursorManagerDataUpdated

cursorManagerSpecificationUpdated

cursorManagerStructureUpdated

CursorManagerUpdateEvent

getCursorManager

Interface CursorManager

Interface CursorManagerUpdateListener

Interface SpecifiedCursorManager

Interface SQLCursorManager

removeCursorManagerUpdateListener

[ Previous Section | Next Section ]

OLAP Reference

OLAP Dynamic Performance Views

Summary of OLAP Dynamic Performance Views

[ Previous Section | Next Section ]

Secure Backup Reference

Database Backup Storage Selectors and RMAN Media Management Parameters

RMAN Media Management Parameters

rmanresourcewaittime

rmanrestorestartdelay

[ Previous Section | Next Section ]

Spatial User's Guide and Reference

Open Geospatial Consortium (OGC) Conformance

Performance and Tuning Information

[ Previous Section | Next Section ]

Streams Advanced Queuing User's Guide and Reference

Oracle Streams AQ Performance and Scalability

[ Previous Section | Next Section ]

Text Reference

German (d) Default Stoplist

German Alternate Spelling Conventions

German and German DIN Language Settings

New German Spelling

[ Previous Section | Next Section ]

Ultra Search Java API Reference (Javadoc)

Class JaznUserManager

Class UserManager

getUserManager

JaznUserManager

setUserManager

UserManager

[ Previous Section | Next Section ]

Upgrade Guide

RMAN

[ Previous Section | Next Section ]

XML Java API Reference (Javadoc)

Class ProviderManagerClient

Class ProviderManagerImpl

createProviderManager

Interface ProviderManager

ProviderManagerClient

ProviderManagerImpl


[Back to top]

Troubleshooting Information About 'Rman'

This category includes information about debugging, preventing errors or handling them when they occur, frequently asked questions, and relevant error messages.

Results in this section come from these books:

[ Next Section ]

2 Day DBA

Diagnosing Performance Problems

Performance Self-Diagnostics: Automatic Database Diagnostics Monitor

[ Previous Section | Next Section ]

Administrator's Guide

Recovering from Permanent Media Failure Using a Control File Copy

[ Previous Section | Next Section ]

Concepts

Performance Diagnostic and Troubleshooting

[ Previous Section | Next Section ]

Performance Tuning Guide

A Sample Decision Process for Performance Conceptual Modeling

Accepting a SQL Profile

Access Path Analysis

Accessing TUNE_MVIEW Output Results

Actions

Actions

Actions

Actions

Actions

Actions

Actions

Actions

Actions

Active Session History (ASH)

Adding and Removing Workload Filters

Adding SQL Statements to a Workload

Additional Hints

Additional Operations on a SQL Tuning Task

Additional Operations on SQL Tuning Sets

Additional Oracle Tools

Additional Statistics

ADDM Analysis Results

Advisor Output

Alignment of Physical Stripe Boundaries with Block Size Boundaries

Allocating Additional Memory for the Library Cache

Allocating Additional Memory to the Data Dictionary Cache

Allow adequate memory to individual users

Altering a SQL Profile

An ADDM Example

Analysis and Reporting

Analyzing Workload Capture

Appending Columns to an Index or Using Index-Organized Tables

Application Considerations

Application Design Principles

Application Modeling

Archived Redo Logs

Assessing I/O for Blocks, not Rows

Asynchronous I/O

Audience

Automatic Database Diagnostic Monitor

Automatic Performance Diagnostics

Automatic Performance Statistics

Automatic Performance Tuning Features

Automatic Shared Memory Management

Automatic SQL Tuning

Automatic SQL Tuning Features

Automatic SQL Tuning Overview

Automatic Statistics Gathering

Avoid Performing DDL

Avoid Transformed Columns in the WHERE Clause

Avoiding Pitfalls in TKPROF Interpretation

Avoiding the Argument Trap

Avoiding the Read Consistency Trap

Avoiding the Schema Trap

Avoiding the Time Trap

Avoiding the Trigger Trap

B-Tree Indexes

Balance the Workload

Baselines

Baselines

Basic I/O Configuration

Benchmarking

Bitmap Indexes

Bitmap Indexes

Block Size Advantages and Disadvantages

Bottleneck Elimination

buffer busy waits

Buffer Cache Advisory Statistics

Buffer Cache Limits

Buffer Pool Data in V$DB_CACHE_ADVICE

Buffer Pool Hit Ratios

By Session

cache buffers chains

cache buffers lru chain

Cache Is Too Big for One DBWR

Cache is Too Small

Cache Sequence Numbers

Caching Session Cursors

Calculating the Buffer Cache Hit Ratio

Canceling Tasks

Capturing a Database Workload

Capturing a Database Workload Using APIs

Capturing a Database Workload Using Enterprise Manager

Capturing the SQL Workload

Cardinality

Cartesian Join Hints

Cartesian Joins

Causes

Causes

Causes

Causes

Changing Load

Changing SQL Statements in Workloads

Checking I/O Management

Checking Memory Management

Checking Network Management

Checking Process Management

Checking System Statistics in the V$SESSTAT View

Checking the Progress of the SQL Tuning Advisor

Checking the Status of a SQL Tuning Task

Choosing an Optimizer Goal

Choosing Between Multiple DBWR Processes and I/O Slaves

Choosing Columns and Expressions to Index

Choosing Composite Indexes

Choosing Data Block Size

Choosing Keys for Composite Indexes

Cluster Access

Column Statistics and Histograms

Combine Multiples Scans with CASE Statements

Compacting Indexes

Components of the Query Optimizer

Compose Predicates Using AND and =

Concurrency of I/O Requests

Configuring a Database for Performance

Configuring and Using the Buffer Cache

Configuring and Using the Redo Log Buffer

Configuring and Using the Shared Pool and Large Pool

Configuring Automatic PGA Memory

Configuring OLAP_PAGE_POOL_SIZE

Configuring the Reserved Pool

Configuring the Right System Architecture for Your Requirements

Configuring Undo Space

Consider Multiple Database Writer (DBWR) Processes or I/O Slaves

Considerations When Gathering Statistics

Considering Multiple Buffer Pools

Context Switching

Controlling the Access Path and Join Order with Hints

Controlling the Behavior of the Query Optimizer

Conventions

Cost

CPU

CPU Statistics

CPU Usage

Creating a Baseline

Creating a SQL Tuning Set

Creating a SQL Tuning Task

Creating and Maintaining Tables for Good Performance

Creating Outlines

Creating Permanent Tablespaces - Automatic Segment-Space Management

Creating Snapshots

Creating Subsequent Tablespaces

Creating Tasks

Creating Templates

Creating Temporary Tablespaces

Cursor Access and Management

CURSOR_SHARING

CURSOR_SHARING for Existing Applications

Customizing PLAN_TABLE Output

data block

Data Modeling

Database Replay

Database Statistics

db file scattered read

db file sequential read

DBMS_ADVISOR.TUNE_MVIEW Procedure

DBWR_IO_SLAVES

DB_WRITER_PROCESSES

Deciding Which Statements to Tune

Define the Problem

Defining the Workload Filters

Defining Workload Contents

Deleting SQL Statements from a Workload

Deleting Tasks

Deploying New Applications

Designing and Developing for Performance

Detecting I/O Problems

Determining an Effective Setting for Shared Server UGA Storage

Determining Stale Statistics

Determining Which Segments Have Many Buffers in the Pool

Developing Efficient SQL Statements

Diagnosing Database Performance Issues with ADDM

Dictionary Cache Concepts

Different Costs

Different Schemas

direct path read and direct path read temp

direct path write and direct path write temp

Disk Statistics

Displaying PLAN_TABLE Output

Displaying the Contents of a SQL Tuning Set

Displaying the Results of a SQL Tuning Task

Do Not Recycle Views

Documentation Accessibility

Dropping a Baseline

Dropping a SQL Profile

Dropping a SQL Tuning Set

Dropping Snapshots

Dynamic Performance Views Containing Wait Event Statistics

Dynamic Sampling Levels

Dynamically Changing Cache Sizes

Editing the TKPROF Output SQL Script

Emergency Performance Methods

Enabling and Controlling Query Optimizer Features

Enabling and Disabling for End to End Tracing

Enabling and Disabling Statistic Gathering for End to End Tracing

Enabling and Disabling Workload Capture

Enabling Automatic Statistics Gathering

Enabling Plan Stability

Enabling Query Optimizer Features

End to End Application Tracing

enqueue (enq:) waits

Estimating

Estimating Statistics with Dynamic Sampling

Estimating the Compression factor

Estimating Workloads

Evaluate Current Usage of Indexes and Materialized Views

Evaluation Mode

events in wait class other

Examine Load

Examine the Host System

Examine the Oracle Statistics

Example 13-1 Using EXPLAIN PLAN

Example 13-10 Full Outer Join

Example 13-2 EXPLAIN PLAN Output

Example 13-3 Effects of Clustering Factor on Cost

Example 13-4 Index Range Scan

Example 13-5 Index Skip Scan

Example 13-6 Sample Table Scan

Example 13-7 Hash Joins

Example 13-8 Hash Join Outer Joins

Example 13-9 Outer Join to a Multitable View

Example 14-1 Viewing Height-Balanced Histogram Statistics

Example 14-2 Viewing Frequency Histogram Statistics

Example 16-1 Specifying a Full Set of Hints

Example 16-2 Using a Query Block in a Hint

Example 16-3 Using Global Hints Example

Example 16-4 Using Global Hints with NO_MERGE

Example 17-1 Creating a Workload

Example 17-2 Creating a Workload from a Template

Example 17-3 Optimizing the Defining Query for Fast Refresh

Example 17-4 Access IMPLEMENTATION Output Through USER_TUNE_MVIEW View

Example 17-5 Save IMPLEMENTATION Output in a Script File

Example 17-6 Enable Query Rewrite by Creating Multiple Materialized Views

Example 17-7 Access IMPLEMENTATION Output Through USER_TUNE_MVIEW View

Example 17-8 Save IMPLEMENTATION Output in a Script File

Example 17-9 Optimized Sub-Materialized View for Fast Refresh

Example 19-1 Looking for Throw-Away in an Explain Plan

Example 19-10 Partial Partition-Wise Join with Range Partition

Example 19-11 Partial Partition-Wise Join with Composite Partition

Example 19-12 Full Partition-Wise Join

Example 19-2 Creating a PLAN_TABLE

Example 19-3 Using EXPLAIN PLAN with the STATEMENT ID Clause

Example 19-4 Using EXPLAIN PLAN with the INTO Clause

Example 19-5 Statement to display the EXPLAIN PLAN

Example 19-6 EXPLAIN PLAN for Statement Id ex_plan1

Example 19-7 EXPLAIN PLAN for Statement Id ex_plan2

Example 19-8 Parallel Query Explain Plan

Example 19-9 EXPLAIN PLAN with Bitmap Indexes

Example 1: Using IN - Selective Filters in the Subquery

Example 2: Using EXISTS - Selective Predicate in the Parent

Example 6-1 Example ADDM Report

Example 6-2 Function for ADDM Analysis on a Pair of Snapshots

Example 6-3 Reporting ADDM Analysis on a Pair of Specific Snapshots

Example 7-1 Calculating the Buffer Cache Hit Ratio

Example 7-2 Initial Setting of PGA_AGGREGATE_TARGET

Example 7-3 Calculating Cache Hit Percentage

Example 7-4 Querying V$SQL_WORKAREA_HISTOGRAM: Non-empty Buckets

Example 7-5 Querying V$SQL_WORKAREA_HISTOGRAM: Percent Optimal

Example 7-6 Querying V$SQL_WORKAREA_ACTIVE

Example 7-7 Querying V$SQL_WORKAREA

Example 7-8 Querying V$PGA_TARGET_ADVICE

Example 7-9 Querying V$PGA_TARGET_ADVICE_HISTOGRAM

Example of Domain Indexes and EXPLAIN PLAN

Example: Find Latches Currently Waited For

Examples of Displaying Range and Hash Partitioning with EXPLAIN PLAN

Examples of Full Partition-wise Joins

Examples of INLIST ITERATOR and EXPLAIN PLAN

Examples of Partial Partition-wise Joins

Examples of Pruning Information with Composite Partitioned Objects

Examples of TKPROF Statement

Examples of Using the SQL Access Advisor

EXECUTE_TASK Procedure

Executing a SQL Tuning Task

Execution Plan in TKPROF

EXPLAIN PLAN Restrictions

Exporting and Importing Statistics

Exporting AWR Data for Workload Capture

Extracting AWR Data

Extrapolating From a Similar System

Factors Preventing Scalability

Fast Full Index Scan Hints

Fast Full Index Scans

Fast Refreshable with Optimized Sub-Materialized View

Figure 10-1 Scattered Read, Sequential Read, and Direct Path Read

Figure 12-1 SQL Tuning Advisor APIs

Figure 12-2 SQL Tuning Sets APIs

Figure 12-3 SQL Profiles APIs

Figure 13-1 Query Optimizer Components

Figure 13-2 Index Skip Scan Illustration

Figure 14-1 height-Balanced Histogram with Uniform Distribution

Figure 14-2 height-Balanced Histogram with Non-Uniform Distribution

Figure 17-1 Materialized Views and the SQL Access Advisor

Figure 17-2 SQL Access Advisor Flowchart

Figure 19-1 A Table Hierarchy

Figure 2-1 Workload Growth Curve

Figure 21-1 Database Replay Architecture

Figure 22-1 SQL Performance Analyzer Workflow

Figure 7-1 Physical I/O and Buffer Cache Size

Figure 7-2 Redo Log Buffer

Figure 7-3 Graphical Representation of V$PGA_TARGET_ADVICE

Figure 8-1 Distributing Redo Members Across Disks

Figure 9-1 Average Workload and Peak Workload

FILESYSTEMIO_OPTIONS Initialization Parameter

Filter a Workload from the SQL Cache

Finding Locks and Lock Holders

Finding System CPU Utilization

Finding the Cost of an Index

Finding the Object Requiring I/O

Finding the SQL Statement executed by Sessions Waiting for I/O

Fit the SGA into main memory

free buffer waits

Frequency Histograms

Full Outer Joins

Full Scans

Full Table Scan Hints

Full Table Scans

Full Table Scans

Function-based Indexes

Gathering Data on the SQL Identified

Gathering Noworkload Statistics

Gathering Statistics with DBMS_STATS Procedures

Gathering Workload Statistics

GATHER_STATS_JOB

Generate Recommendations Using a Task Template

Generating a Workload Capture Report Using APIs

Generating a Workload Capture Report Using Enterprise Manager

Generating Active Session History Reports

Generating Automatic Workload Repository Reports

Generating Plans

Generating Recommendations

Generating SQL Scripts

Generating the TKPROF Output SQL Script

Glossary

Goals for Tuning

Handling Missing Statistics

Hardware and Software Components

Hardware Components

Hash Access

Hash Area Size

Hash Join Hints

Hash Join Outer Joins

Hash Joins

Height-Balanced Histograms

High Degree of Parallelism

High Rates of Activity

Hints and Complex Views

Hints and Mergeable Views

Hints and Nonmergeable Views

Hints by Category

Hints for Access Paths

Hints for Join Operations

Hints for Join Orders

Hints for Optimization Approaches and Goals

Hints for Parallel Execution

Hints for Query Transformations

How Dynamic Sampling Works

How Execution Plans Can Change

How Outlines Use Hints

How the Query Optimizer Chooses an Access Path

How the Query Optimizer Chooses Execution Plans for Joins

How the Query Optimizer Executes Join Statements

How to Tune PGA_AGGREGATE_TARGET

How to Use Dynamic Sampling to Improve Performance

HW enqueue

I/O Configuration and Design

I/O Subsystem

Identification of User Issuing the SQL Statement in TKPROF

Identifying Contention for Shared Servers

Identifying Contention Using the Dispatcher-Specific Views

Identifying High-Load SQL

Identifying Resource-Intensive SQL

Identifying Statements for EXPLAIN PLAN

Idle Wait Events

Implement and Measure Change

Implementing Business Logic

Implementing the Application

Inadequate I/O Distribution

Increasing Memory Allocated to the Buffer Cache

Increasing Memory Allocation

Index Join Hints

Index Joins

Index Range Scan Descending Hints

Index Range Scan Hints

Index Range Scans

Index Range Scans Descending

Index Scans

Index Skip Scans

Index Tuning using the SQLAccess Advisor

Index Unique Scan Hints

Index Unique Scans

Indexing Data

Information to Gather During Tuning

Initialization Parameters

Inner loop

Input Sources

Instance Tuning

Instance Tuning Steps

Instance Tuning Using Performance Views

Interpreting and Using the Buffer Cache Advisory Statistics

Interpreting CPU Statistics

Interpreting Oracle Statistics

Interpreting Shared Pool Statistics

Interpreting Statistics

Interpreting the Resolution of Statistics

Interrupting Tasks

Introduction to Database Diagnostic Monitoring

Introduction to Performance Tuning

Introduction to Performance Tuning Features and Tools

Introduction to SQL Tuning

Iteration During Configuration

KEEP Pool

Keeping Large Objects to Prevent Aging

Lack of Index

Large Amount of Data

latch events

Lay Out the Files Using Operating System or Hardware Striping

Library Cache Concepts

library cache lock

Library Cache Misses in TKPROF

library cache pin

Limiting Memory Use for Each User Session by Setting PRIVATE_SGA

Linking Tasks and Workloads

List I/O Interfaces to Submit Multiple Asynchronous I/Os in One Call

Loading a SQL Tuning Set

Loading AWR Data

Loading SQL Cache Workloads

Loading User-Defined Workloads

Locking Statistics

Locking Statistics for a Table or Schema

log buffer space

Log Buffer Statistics

log file parallel write

log file switch

log file sync

Looking Beyond Execution Plans

Maintaining Connections

Maintaining Execution Plans Over Time

Maintaining Workloads

Manageability of the Proposed System

Managing a Completed Workload Capture

Managing Baselines

Managing Data and Transactions

Managing Excessive I/O

Managing Optimizer Statistics

Managing Snapshots

Managing Statistics

Managing Tasks

Managing the Automatic Workload Repository

Managing the User Interface

Managing User Requests and Resource Allocation

Managing Workloads

Manual Statistics Gathering

Manually Distributing I/O

Marking Recommendations

Memory

Memory Configuration and Use

Memory Usage

Memory-mapped System Timer

Minimizing Throw-Away

Modify All the Data Needed in One Statement

Modifying a SQL Tuning Set

Modifying or Disabling Triggers and Constraints

Modifying Recommendations

Modifying Snapshot Settings

Monitoring an Active Workload Capture

Monitoring the Performance of the Automatic PGA Memory Management

Monitoring Workload Capture Using Enterprise Manager

Monitoring Workload Capture Using Views

Move Archive Logs to Different Disks

Move Redo Logs to Separate Disks

Moving from RBO to the Query Optimizer

Moving Outline Tables

Moving to a New Oracle Release under the Query Optimizer

Multiblock Read Count

Nested Loop Example

Nested Loop Join Hints

Nested Loop Joins

Nested Loop Outer Joins

Nesting Nested Loops

Network

Network

Network Bottleneck

Network Statistics

Non-Oracle Processes

Normal mode

Noworkload Statistics

Operating System Data Gathering Tools

Operating System Memory Use

Operating System Statistics

Optimizer Operations

Optimizer SQL Hints for Changing the Query Optimizer Goal

OPTIMIZER_MODE Initialization Parameter

Optimizing Instance Performance

Optimizing SQL Statements

OR-expansion

Oracle CPU Statistics

Oracle Memory Caches

Oracle Methodology

Oracle Processes

Oracle Real Application Cluster Instances

Oracle-Managed Files

Ordering Columns in an Index

Ordering Keys for Composite Indexes

Outer Joins

Outer loop

Oversize Page Tables

Overview of Data Gathering

Overview of Database Replay

Overview of EXPLAIN PLAN

Overview of SQL Performance Analyzer

Overview of the Automatic Workload Repository

Overview of the SQL Access Advisor in the DBMS_ADVISOR Package

Overview of Using the SQL Access Advisor

Paging and Swapping

Parallel Query Execution

Parallel Statistics Gathering

Parallelize the Workload

Parameters Affecting Memory Usage

Parse-Related Statistics

Partitioned Indexes

Peeking of User-Defined Bind Variables

Performance Checklist

Performance Considerations for Initial Instance Configuration

Performance Considerations for Shared Servers

Performance Hints on HP OpenVMS Systems

Performance Hints on UNIX-Based Systems

Performance Hints on Windows Systems

Performance Improvement Methods

Performance Planning

Performance Planning

Performance Principles

Performance Tuning

Performance Tuning Overview

Performing a Quick Tune

PGA Memory Management

Plans for Hash Partitioning

PLAN_TABLE Columns

Post-wait Driver

Predicate Pushing

Preface

Prerequisites for Capturing a Database Workload

Privileges Needed to Use the SQL Access Advisor

Proactive Monitoring

Query Optimizer and Execution Plans

Query Optimizer Modes

Query Optimizer Statistics in the Data Dictionary

Query Rewrite with Materialized Views

Querying the Output Table

Random Access to Large Segments

rdbms ipc reply

Re-creating Indexes

Read Consistency

Reading and Understanding Execution Plans

Reading EXPLAIN PLAN Output

Reads

Real Application Testing

Reclaiming Unused Space

Recommendation Options

Recommendations From a User-Defined Workload

RECYCLE Pool

Redo Log Files

Redo Log Space Requests Statistic

Reduce paging

Reduce the Workload

Reducing Contention for Dispatcher Processes

Reducing Memory Allocated to the Buffer Cache

Reducing Memory Allocation

Reducing Memory Use with Three-Tier Connections

Reducing Parse Calls with JDBC

Reducing Parse Calls with OCI

Reducing Parse Calls with Oracle Forms

Reducing Parse Calls with SQLJ

Reducing Parse Calls with the Oracle Precompilers

Related Documents

Removing a Link Between a Workload and a Task

Removing Workloads

Reparsed Sharable SQL

Requested I/O Size

Resetting Workloads

Resource Bottleneck on the Client Process

Restarting the Database

Restoring Previous Versions of Statistics

Restoring Previous Versions of Statistics

Restoring Statistics Versus Importing or Exporting Statistics

Restructuring the Data

Restructuring the Indexes

Restructuring the SQL Statements

Reverse Key Indexes

Reviewing the Execution Plan

Rollout Strategies

row cache objects

Row Source Operations

Rowid Scans

Running ADDM Using addmrpt.sql

Running ADDM using DBMS_ADVISOR APIs

Running EXPLAIN PLAN

Running the ashrpt.sql Report

Running the ashrpti.sql Report

Running the awrddrpi.sql Report

Running the awrddrpt.sql Report

Running the awrrpt.sql Report

Running the awrrpti.sql Report

Running the awrsqrpi.sql Report

Running the awrsqrpt.sql Report

Sample Output of trcsess

Sample Table Scans

Sample TKPROF Body

Sample TKPROF Header

Sample TKPROF Output

Sample TKPROF Output

Sample TKPROF Summary

Scheduling and Switching

Script Generation DBMS_ADVISOR Function and Procedure

segment header

Segment-Level Statistics

Selectivity

Serializing within Indexes

Setting PGA_AGGREGATE_TARGET Initially

Setting Statistics

Setting the DAYS_TO_EXPIRE Parameter

Setting the Level of Statistics Collection

Setting Up ADDM

Setting Up Tasks and Templates

Setting Up the Capture Directory

Setting Workload Attributes

Shared Cursors

Shared Pool Advisory Statistics

Shared Pool and Library Cache Latch Contention

Shared Pool Concepts

Shared Pool: Dictionary Cache Statistics

Shared Pool: Library Cache Statistics

Similar SQL Statements

Simplicity In Application Design

Single-User Logon and Qualified Table Reference

Sizing Data

Sizing Redo Log Files

Sizing the Buffer Cache

Sizing the Log Buffer

Sizing the Shared Pool

Small Table

Snapshots

Software Components

Solving Operating System Problems

Sort Merge Join Hints

Sort Merge Joins

Sort Merge Outer Joins

Sorts to Disk

Space Consumption

Specifying a Full Set of Hints

Specifying a Query Block in a Hint

Specifying Complex Index Hints

Specifying Different Tables for EXPLAIN PLAN

Specifying Global Table Hints

Specifying Hints

Specifying Memory for Sorting Data

SQL Access Advisor

SQL Access Advisor Repository

SQL Access Advisor Workload Parameters

SQL Execution Efficiency

SQL Performance Analyzer

SQL Profiles

SQL Profiling

SQL Sharing Criteria

SQL Structure Analysis

SQL Tuning

SQL Tuning Advisor

SQL Tuning Information Views

SQL Tuning Overview

SQL Tuning Sets

SQL Tuning Sets

SQL Workload Journal

SQL*Net Events

SQL*Net message from client

SQL*Net message from dblink

SQL*Net more data to client

ST enqueue

Starting a Workload Capture

Starting New Operating System Processes

Statement Truncation in SQL Trace

Statistic Gathering for Client Identifier

Statistic Gathering for Service, Module, and Action

Statistics Analysis

Statistics Gathering Using Sampling

Statistics on Partitioned Objects

Statistics on Tables, Indexes and Columns

Step 1: Setting Initialization Parameters for Trace File Management

Step 2: Enabling the SQL Trace Facility

Step 3: Formatting Trace Files with TKPROF

Step 4: Interpreting TKPROF Output

Step 5: Storing SQL Trace Facility Statistics

Steps for Using the SQL Access Advisor

Steps in the Emergency Performance Method

Steps in the Execution Plan

Steps in The Oracle Performance Improvement Method

Stopping a Workload Capture

Stopping an Active Workload Capture

Stopping the Recommendation Process

Store Intermediate Results

Storing Outlines

Stripe Everything Across Every Disk

Subquery Unnesting

Syntax for trcsess

Syntax of TKPROF

System and Session Statistics

System Architecture

System Scalability

System Statistics

System Statistics

Table and Index Design

Table Compression

Table Fetch by Continued Row

Table of Wait Events and Potential Causes

Tables, Indexes, and TEMP Tablespaces

Tabular Statistics in TKPROF

Testing, Debugging, and Validating a Design

The Oracle Performance Improvement Method

The PLAN_TABLE Output Table

The Query Optimizer

The Symptoms and the Problems

Three Sample Configurations

Time Model Statistics

TKPROF Example 1

TKPROF Example 2

TM enqueue

Top Ten Mistakes Found in Oracle Systems

Tracing for Client Identifier

Tracing for Entire Instance or Database

Tracing for Service, Module, and Action

Tracing for Session

Transforming Queries

Transporting a SQL Tuning Set

Transporting Automatic Workload Repository Data

Trends in Application Development

TUNE_MVIEW Syntax and Operations

Tuning a Specific Program

Tuning an Application / Reducing Load

Tuning Materialized Views for Fast Refresh and Query Rewrite

Tuning mode

Tuning Options

Tuning Oracle-Managed Files

Tuning PGA_AGGREGATE_TARGET

Tuning the Large Pool and Shared Pool for the Shared Server Architecture

Tuning the Logical Structure

Tuning to Achieve a Better Compression Ratio

TX enqueue

Types of Hints

Types of Tuning Analysis

Understanding Access Paths for the Query Optimizer

Understanding CPU

Understanding EXPLAIN PLAN

Understanding I/O

Understanding Index Performance

Understanding Investment Options

Understanding Joins

Understanding Memory Allocation Issues

Understanding Operating System Performance Issues

Understanding Operating System Resources

Understanding Optimizer Hints

Understanding Recursive Calls

Understanding Scalability

Understanding SQL Trace and TKPROF

Understanding Statistics

Understanding the Query Optimizer

Understanding the SQL Trace Facility

Understanding TKPROF

undo block

undo header

Unshared SQL

Updating Task Attributes

Upgrading with a Test System

Use Caution When Joining Complex Views

Use Caution When Managing Views

Use Caution When Performing Outer Joins to Views

Use Caution When Unnesting Subqueries

Use DML with RETURNING Clause

Use of EXISTS versus IN for Subqueries

Use of PL/SQL

User-defined Statistics

USER_TUNE_MVIEW and DBA_TUNE_MVIEW Views

Using a Different Index Type

Using a Workload Capture Report

Using Application Tracing Tools

Using Automatic Workload Repository Views

Using Bitmap Indexes for Performance

Using Bitmap Join Indexes for Performance

Using Category Names for Stored Outlines

Using Clusters for Performance

Using CURSOR_SPACE_FOR_TIME

Using Domain Indexes for Performance

Using Enabled Novalidated Constraints

Using EXPLAIN PLAN

Using Function-based Indexes for Performance

Using Hash Clusters for Performance

Using Hints with Plan Stability

Using Hints with Views

Using Hypothetical Workloads

Using Index-Organized Tables for Performance

Using Indexes and Clusters

Using Multiple Buffer Pools

Using Nonunique Indexes to Enforce Uniqueness

Using Operating System Caches

Using Operating System Resource Managers

Using Optimizer Hints

Using Partitioned Indexes for Performance

Using Plan Stability

Using Plan Stability to Preserve Execution Plans

Using Plan Stability with Query Optimizer Upgrades

Using SHARED_POOL_RESERVED_SIZE

Using SQL Access Advisor Constants

Using SQL Tuning Advisor APIs

Using Stored Outlines

Using Summary Advisor Oracle Database 9i Workloads

Using Supplied Packages to Manage Stored Outlines

Using Templates

Using the Buffer Cache Effectively

Using the Large Pool

Using the Shared Pool Effectively

Using the SQL Access Advisor

Using the SQL Trace Facility and TKPROF

Using the trcsess Utility

Using V$DB_CACHE_ADVICE

Using V$SQL_PLAN Views

Using Views

Using Wait Event Statistics to Drill Down to Bottlenecks

Using Workloads

V$ Performance Views

V$ACTIVE_SESSION_HISTORY

V$ENQUEUE_STAT

V$FILESTAT

V$JAVA_POOL_ADVICE and V$JAVA_LIBRARY_CACHE_MEMORY

V$LATCH

V$LIBRARYCACHE

V$LIBRARY_CACHE_MEMORY

V$PGASTAT

V$PGA_TARGET_ADVICE

V$PGA_TARGET_ADVICE_HISTOGRAM

V$PROCESS

V$PROCESS_MEMORY

V$ROLLSTAT

V$SHARED_POOL_ADVICE

V$SQL_WORKAREA

V$SQL_WORKAREA_ACTIVE

V$SQL_WORKAREA_HISTOGRAM

V$STATISTICS_LEVEL

V$SYSSTAT

V$SYSSTAT and V$SESSTAT

Verifying Optimizer Statistics

View Merging

Viewing Bitmap Indexes with EXPLAIN PLAN

Viewing Enabled Traces for End to End Tracing

Viewing Gathered Statistics for End to End Application Tracing

Viewing Histograms

Viewing Information About Dynamic Resize Operations

Viewing Outline Data

Viewing Parallel Execution with EXPLAIN PLAN

Viewing Parallel Queries with EXPLAIN PLAN

Viewing Partitioned Objects with EXPLAIN PLAN

Viewing Recommendations

Viewing Statistics

Views with ADDM Information

Virtual Memory Statistics

Visiting Data as Few Times as Possible

Wait Event Information

Wait Events

Wait Events

Wait Events Statistics

What is Scalability?

What's New in Oracle Performance?

When Recommendations are no Longer Required

When SHARED_POOL_RESERVED_SIZE Is Too Large

When SHARED_POOL_RESERVED_SIZE Is Too Small

When SHARED_POOL_SIZE is Too Small

When the IN-List Column is a Partition Column

When the IN-List Column is an Index and a Partition Column

When the IN-List Column is an Index Column

When the Optimizer Uses Cartesian Joins

When the Optimizer Uses Full Table Scans

When the Optimizer Uses Hash Joins

When the Optimizer Uses Index Range Scans

When the Optimizer Uses Index Range Scans Descending

When the Optimizer Uses Index Unique Scans

When the Optimizer Uses Nested Loop Joins

When the Optimizer Uses Rowids

When the Optimizer Uses Sort Merge Joins

When to Gather Statistics

When to Separate Files

When to Tune

When to use CURSOR_SHARING

When to Use Dynamic Sampling

When to Use Manual Statistics

Why a Full Table Scan Is Faster for Accessing Large Amounts of Data

Working with Recommendations

Workload Capture

Workload Capture Options

Workload Capture Restrictions

Workload Objects

Workload Preprocessing

Workload Replay

Workload Statistics

Workload Testing, Modeling, and Implementation

Write Separate SQL Statements for Specific Tasks

Writes

Writes

Writing Statements That Avoid Using Indexes

Writing Statements That Use Indexes

[ Previous Section | Next Section ]

PL/SQL User's Guide and Reference

Guidelines for Avoiding PL/SQL Performance Problems

[ Previous Section | Next Section ]

2 Day + Performance Tuning Guide

About This Guide

Accessing Previous ADDM Results

Active Session History Statistics

Activity Over Time

Advisory Statistics

Audience

Automatic Database Performance Monitoring

Buffer Wait Statistics

Clearing Alerts

Common Oracle DBA Tasks

Common Performance Problems Found in Oracle Databases

Comparing a Baseline to Another Baseline or Pair of Snapshots

Comparing Two Pairs of Snapshots

Complete List of SQL Text

Complete List of SQL Text

Configuration Comparison

Configuring the Automatic Database Diagnostics Monitor

Conventions

Creating a SQL Tuning Set

Creating a SQL Tuning Set: Filter Options

Creating a SQL Tuning Set: Load Method

Creating a SQL Tuning Set: Options

Creating a SQL Tuning Set: Schedule

Creating Baselines

Creating Snapshots

Defining Filters for Actions

Defining Filters for Module ID

Defining Filters for Resource Consumption

Defining Filters for SQL Text

Defining Filters for Tables

Defining Filters for Users

Deleting a SQL Tuning Set

Dictionary Cache Statistics

Documentation Accessibility

Enqueue Activity

Figure 11-1 Scheduling a SQL Access Advisor Task

Figure 2-1 DB Time in Overall User Response Time

Figure 2-2 DB Time in User Transaction

Figure 2-3 Active Session History

Figure 3-1 Diagnostic Summary

Figure 3-2 Automatic Database Diagnostic Monitor (ADDM) Page

Figure 3-3 Performance Analysis

Figure 4-1 Database Performance Page

Figure 4-10 Monitoring Top Actions

Figure 4-11 Monitoring Instance Activity

Figure 4-12 Monitoring Host Activity

Figure 4-13 Performance Summary

Figure 4-2 Monitoring User Activity

Figure 4-3 Active Sessions Working page

Figure 4-4 Monitoring Top SQL

Figure 4-5 Monitoring Top Sessions

Figure 4-6 Viewing Session Details

Figure 4-7 Monitoring Top Services

Figure 4-8 Viewing Service Details

Figure 4-9 Monitoring Top Modules

Figure 5-1 Responding to Alerts

Figure 6-1 Analyzing Current Database Performance

Figure 6-2 Analyzing Historical Database Performance

Figure 7-1 ASH Report Results

Figure 7-2 Top User Events

Figure 7-3 Top Event P1/P2/P3 Values

Figure 7-4 Top Service/Module

Figure 7-5 Top SQL Command Types

Figure 7-6 Top SQL Statements

Figure 7-7 Top Sessions

Figure 7-8 Activity Over Time

Figure 8-1 AWR Compare Periods Report

Figure 8-2 Snapshot Sets

Figure 8-3 Top 5 Timed Events

Figure 8-4 Wait Events

Figure 8-5 Time Model Statistics

Figure 8-6 Top 10 SQL Comparison by Execution Time

Figure 8-7 Top 5 Segments Comparison by Logical Reads

Figure 9-1 Top Activity Page

Figure 9-2 Viewing SQL Statement By Wait Class

Figure 9-3 SQL Details Page

Figure 9-4 Viewing SQL Text

Figure 9-5 Viewing SQL Statistics

Figure 9-6 Viewing Session Activity

Figure 9-7 Viewing SQL Execution Plan

Figure 9-8 Viewing SQL Tuning Information

Gathering Database Statistics Using the Automatic Workload Repository

Getting Started

High-Load SQL Statistics

I/O Statistics

Identifying High-Load SQL Statements

Identifying High-Load SQL Statements Using ADDM Findings

Identifying High-Load SQL Statements Using Top SQL

Implementing ADDM Recommendations

Implementing the SQL Access Advisor Recommendations

init.ora Parameters

Instance Activity Statistics

Interpreting the Automatic Database Diagnostics Monitor Findings

Introduction

Key Instance Activity Statistics

Latch Statistics

Library Cache Statistics

List of Figures

List of Tables

Load Profile

Load Profiles

Loading Active SQL Statements Incrementally from the Cursor Cache

Loading SQL Statements from a User-Defined Workload

Loading SQL Statements from AWR Snapshots

Loading SQL Statements from Preserved Snapshot Sets

Loading SQL Statements from the Cursor Cache

Managing Snapshots

Managing SQL Profiles

Managing SQL Tuning Sets

Manual Database Performance Monitoring

Manually Running ADDM to Analyze Current Database Performance

Manually Running ADDM to Analyze Historical Database Performance

Modifying Snapshot Settings

Monitoring CPU Utilization

Monitoring Disk I/O Utilization

Monitoring Host Activity

Monitoring Instance Activity

Monitoring Memory Utilization

Monitoring Performance Alerts

Monitoring Real-Time Database Performance

Monitoring Top Actions

Monitoring Top Modules

Monitoring Top Services

Monitoring Top Sessions

Monitoring Top SQL

Monitoring User Activity

Operating System Statistics

Optimizing Data Access Paths

Oracle Database Performance Method

Other Instance Activity Statistics

Overview of Active Session History

Overview of the Automatic Database Diagnostic Monitor

PGA Aggregate Summary

PGA Aggregate Target Statistics

Preface

Preparing the Database for Tuning

Proactive Database Tuning

Reactive Database Tuning

Related Documents

Report Summary

Resolving Performance Degradation Over Time

Resolving Transient Performance Problems

Responding to Alerts

Reviewing the Automatic Database Diagnostics Monitor Analysis

Reviewing the SQL Access Advisor Recommendations

Reviewing the SQL Access Advisor Recommendations: Details

Reviewing the SQL Access Advisor Recommendations: Recommendations

Reviewing the SQL Access Advisor Recommendations: SQL Statements

Reviewing the SQL Access Advisor Recommendations: Summary

Running Active Session History Reports

Running the Automatic Workload Repository Compare Periods Reports

Running the SQL Access Advisor

Running the SQL Access Advisor: Filter Options

Running the SQL Access Advisor: Initial Options

Running the SQL Access Advisor: Recommendation Options

Running the SQL Access Advisor: Schedule

Running the SQL Access Advisor: Workload Source

Segment Statistics

Service Statistics

Session and System Statistics

Setting Metric Thresholds for Performance Alerts

Setting the DBIO_EXPECTED parameter

Setting the STATISTICS_LEVEL parameter

SGA Breakdown Difference

SGA Memory Summary

SGA Statistics

Snapshot Sets

SQL Statistics

SQL Tuning

Tablespace I/O Statistics

Time Model Statistics

Time Model Statistics

Tools for Tuning the Database

Top 10 File Comparison by Buffer Waits

Top 10 File Comparison by I/O

Top 10 File Comparison by Read Time

Top 10 SQL Comparison by Buffer Gets

Top 10 SQL Comparison by CPU Time

Top 10 SQL Comparison by Execution Time

Top 10 SQL Comparison by Executions

Top 10 SQL Comparison by Physical Reads

Top 10 SQL Comparisons by Parse Calls

Top 5 Segments by Buffer Busy Waits

Top 5 Segments by ITL Waits

Top 5 Segments by Row Lock Waits

Top 5 Segments Comparison by Logical Reads

Top 5 Segments Comparison by Physical Reads

Top 5 Timed Events

Top Background Events

Top Blocking Sessions

Top Client IDs

Top DB Files

Top DB Objects

Top Event P1/P2/P3 Values

Top Events

Top Latches

Top Objects/Files/Latches

Top Service/Module

Top Sessions

Top Sessions

Top Sessions Running PQs

Top SQL

Top SQL Command Types

Top SQL Statements

Top SQL Using Literals

Top User Events

Transporting a SQL Tuning Set

Tuning SQL Statements

Tuning SQL Statements

Tuning SQL Statements Using the SQL Tuning Advisor

Tuning the Database Proactively

Tuning the Database Reactively

Using a Hypothetical Workload

Using a User-Defined Workload

Using Active Session History Reports

Using an Existing SQL Tuning Set

Using SQL Statements from the Cache

Using the Automatic Workload Repository Compare Periods Reports

Using the Oracle Performance Method

Viewing Activity by Wait Statistics and Activity by Time Statistics

Viewing Details of SQL Statements

Viewing Elapsed Time Breakdown Statistics

Viewing General SQL Statistics

Viewing Other SQL Statistics

Viewing Session Activity

Viewing Shared Cursors Statistics and Execution Statistics

Viewing Snapshot Statistics

Viewing SQL Execution Plan

Viewing SQL Statements by Wait Class

Viewing SQL Statistics

Viewing SQL Statistics Summary

Viewing SQL Tuning Information

Wait Event Statistics

Wait Events

Wait Statistics

[ Previous Section | Next Section ]

2 Day + Real Application Clusters Guide

Monitoring Oracle RAC Database Performance

Reviewing Other Performance-Related Charts

Using Performance Views in Oracle Real Application Clusters

Using the Cluster Database Performance Page

[ Previous Section | Next Section ]

Access Manager for AS/400 Installation and User's Guide for IBM iSeries OS/400

Performance

[ Previous Section | Next Section ]

Backup and Recovery Advanced User's Guide

After Installation of Media Manager, RMAN Channel Allocation Fails: Diagnosis

After Installation of Media Manager, RMAN Channel Allocation Fails: Scenario

After Installation of Media Manager, RMAN Channel Allocation Fails: Solution

Backup Fails Because RMAN Cannot Locate an Archived Log: Diagnosis

Backup Fails Because RMAN Cannot Locate an Archived Log: Scenario

Backup Fails Because RMAN Cannot Locate an Archived Log: Solution

Components of an RMAN Session

Duplication Fails with Multiple RMAN-06023 Errors: Diagnosis

Duplication Fails with Multiple RMAN-06023 Errors: Scenario

Duplication Fails with Multiple RMAN-06023 Errors: Solution

Handling I/O Errors in RMAN Backup: NOT BACKED UP SINCE

How RMAN Responds to Backup Errors

Identifying RMAN Return Codes

Interpreting RMAN Error Stacks

Interpreting RMAN Errors: Example

Interpreting RMAN Message Output

Limitations of RMAN TRANSPORT TABLESPACE Command

Recognizing RMAN Error Message Stacks

RMAN Denies Logon to Target Database: Diagnosis

RMAN Denies Logon to Target Database: Scenario

RMAN Denies Logon to Target Database: Solution

RMAN Does Not Recognize Character Set Name: Diagnosis

RMAN Does Not Recognize Character Set Name: Scenario

RMAN Does Not Recognize Character Set Name: Solution

RMAN DUPLICATE DATABASE: Prerequisites and Restrictions

RMAN Error Message Numbers

RMAN Fails to Delete All Archived Logs: Diagnosis

RMAN Fails to Delete All Archived Logs: Scenario

RMAN Fails to Delete All Archived Logs: Solution

RMAN Fails to Start RPC Call: Diagnosis

RMAN Fails to Start RPC Call: Scenario

RMAN Troubleshooting Scenarios

Terminating an RMAN Command

Terminating an RMAN Session That Is Hung in the Media Manager

Terminating an RMAN Session: Basic Steps

Troubleshooting RMAN TRANSPORT TABLESPACE

Troubleshooting RMAN TRANSPORT TABLESPACE: Filename Conflicts

Troubleshooting RMAN TRANSPORT TABLESPACE: Insufficient Shared Pool

Troubleshooting RMAN TSPITR

Troubleshooting TSPITR: RMAN Cannot Identify Tablespaces with Undo Segments

[ Previous Section | Next Section ]

Backup and Recovery Basics

Limiting RMAN CROSSCHECK to a Backups Since a Specific Time

[ Previous Section | Next Section ]

Data Guard Broker

The Request Timed Out or Enterprise Manager Performance Is Sluggish

[ Previous Section | Next Section ]

Data Guard Concepts and Administration

Slow Disk Performance on Standby Databases

[ Previous Section | Next Section ]

Data Warehousing Guide

Monitoring and Diagnosing Parallel Execution Performance

[ Previous Section | Next Section ]

Enterprise Manager Advanced Configuration

Configuring OC4J for Request Performance Diagnostics

Improving the Login Performance of the Console Home Page

Selecting OC4J Targets for Request Performance Diagnostics

Verifying and Troubleshooting End-User Performance Monitoring

[ Previous Section | Next Section ]

Enterprise Manager Concepts

Diagnosing Identity Management Performance and Availability Problems

Diagnosing Identity Management Performance and Availability Problems

Diagnosing Oracle Collaboration Suite Performance and Availability Problems

Diagnosing Performance Issues with Top Reports

Request Performance Diagnostics

[ Previous Section | Next Section ]

Error Messages

DRG-11600: URL store: string has permanently moved

DRG-11812: Moved Permanently

ORA-01268: invalid TEMPFILE clause for alter of permanent TABLESPACE

ORA-01660: tablespace "string" is already permanent

ORA-02196: PERMANENT/TEMPORARY option already specified

ORA-03245: Tablespace has to be dictionary managed, online and permanent to be able to migrate

ORA-12911: permanent tablespace cannot be temporary tablespace

ORA-12916: Cannot use default permanent tablespace with this release

ORA-12918: Invalid tablespace type for default permanent tablespace

ORA-12919: Can not drop the default permanent tablespace

ORA-12950: SYSTEM tablespace specified as default permanent tablespace

ORA-12951: Attempt to change default permanent tablespace to temporary

ORA-19677: RMAN configuration name exceeds maximum length of string

ORA-19678: RMAN configuration value exceeds maximum length of string

ORA-19679: RMAN configuration number string is outside valid range of 1 through string

ORA-29279: SMTP permanent error: string

RMAN-00550 to RMAN-20507

RMAN-00550: parser package failed to load

RMAN-00551: initialization of parser package failed

RMAN-00552: syntax error in command line arguments

RMAN-00553: internal recovery manager package failed to load

RMAN-00554: initialization of internal recovery manager package failed

RMAN-00555: target database connect string must be specified

RMAN-00556: could not open CMDFILE "string"

RMAN-00557: could not open MSGLOG "string"

RMAN-00558: error encountered while parsing input commands

RMAN-00562: username too long

RMAN-00563: password too long

RMAN-00564: host data too long

RMAN-00565: unable to read input file

RMAN-00566: could not open TRACE "string"

RMAN-00567: Recovery Manager could not print some error messages

RMAN-00568: user interrupt received

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00570: **end-of-file**

RMAN-00571: ===========================================================

RMAN-00572: waiting for dbms_pipe input

RMAN-00573: dbms_pipe.next_item_time returned unknown type code: number

RMAN-00574: rman aborting due to errors read/writing dbms_pipe

RMAN-00575: timeout while trying to write to dbms_pipe

RMAN-00576: PIPE cannot be used with CMDFILE

RMAN-00577: PIPE requires that TARGET be specified on the command line

RMAN-00578: pipe string is not private and owned by SYS

RMAN-00579: SCRIPT cannot be used with CMDFILE

RMAN-00600: internal error, arguments [string] [string] [string] [string] [string]

RMAN-00601: fatal error in recovery manager

RMAN-00700: SCRIPT requires that TARGET be specified on the command line

RMAN-00701: SCRIPT requires that CATALOG be specified on the command line

RMAN-00702: The command has no syntax errors

RMAN-00703: The cmdfile has no syntax errors

RMAN-01006: error signalled during parse

RMAN-01007: at line number column number file: string

RMAN-01008: the bad identifier was: string

RMAN-01009: syntax error: found "string": expecting one of: "string"

RMAN-02000: wrong message file version (msg number not found)

RMAN-02001: unrecognized punctuation symbol "string"

RMAN-02002: unexpected end of input file reached

RMAN-02003: unrecognized character: string

RMAN-02004: quoted string too big

RMAN-02005: token too big

RMAN-02006: script line too long

RMAN-02007: Integer value overflow

RMAN-03000: recovery manager compiler component initialization failed

RMAN-03001: recovery manager command sequencer component initialization failed

RMAN-03002: failure of string command at string

RMAN-03003: command not implemented yet: string

RMAN-03004: fatal error during execution of command

RMAN-03008: error while performing automatic resync of recovery catalog

RMAN-03009: failure of string command on string channel at string

RMAN-03010: fatal error during library cache pre-loading

RMAN-03011: Recovery Managerstring

RMAN-03012: fatal error during compilation of command

RMAN-03013: Copyright (c) 1995, 2003, Oracle Corporation. All rights reserved.

RMAN-03014: implicit resync of recovery catalog failed

RMAN-03015: error occurred in stored script string

RMAN-03017: recursion detected in stored script string

RMAN-03018: asynchronous RPCs are working correctly

RMAN-03019: asynchronous RPCs are NOT working

RMAN-03020: asynhronous RPC test will take 1 minute

RMAN-03023: executing command: string

RMAN-03028: fatal error code for command string : number

RMAN-03029: echo set on

RMAN-03030: echo set off

RMAN-03031: this option of set command needs to be used inside a run block

RMAN-03032: this option of set command needs to be used outside of a run block

RMAN-03033: current log archived

RMAN-03034: LEVEL number is invalid. LEVEL must be between string and string

RMAN-03035: Debugging turned off

RMAN-03036: Debugging set to level=number, types=string

RMAN-03037: Spooling started in log file: string

RMAN-03038: Spooling started in trace file: string

RMAN-03039: Spooling for log turned off

RMAN-03040: Spooling for trace turned off

RMAN-03090: Starting string at string

RMAN-03091: Finished string at string

RMAN-03098: %-*sRMAN-number: stringstring

RMAN-03099: job cancelled at user request

RMAN-03999: Oracle error occurred while while converting a date: ORA-number: string

RMAN-04000: memory allocation failure

RMAN-04001: heap initialization failure

RMAN-04002: ocipi failed, ORA-string

RMAN-04003: ociinit failed

RMAN-04004: error from recovery catalog database: string

RMAN-04005: error from target database: string

RMAN-04006: error from auxiliary database: string

RMAN-04007: WARNING from recovery catalog database: string

RMAN-04008: WARNING from target database: string

RMAN-04009: WARNING from auxiliary database: string

RMAN-04010: target database Password:

RMAN-04011: recovery catalog database Password:

RMAN-04012: auxiliary database Password:

RMAN-04013: must connect before startup

RMAN-04014: startup failed: string

RMAN-04015: error setting target database character set to string

RMAN-04016: could not get OCI error handle

RMAN-04017: startup error description: string

RMAN-04020: target database name "string" does not match channel"s name: "string"

RMAN-04021: target database DBID string does not match channel"s DBID string

RMAN-04022: target database mount id string does not match channel"s mount id string

RMAN-04024: starting Oracle instance without parameter file for retrival of spfile

RMAN-04025: unable to generate a temporary file

RMAN-04026: unable to open a temporary file: "string"

RMAN-04027: unable to write to a temporary file: "string"

RMAN-04031: initialization parameters used for automatic instance: string

RMAN-04032: using contents of file string

RMAN-04033: cannot open auxiliary parameter file string

RMAN-05000: CONFIGURE AUXNAME required for datafile string

RMAN-05001: auxiliary filename string conflicts with a file used by the target database

RMAN-05002: aborting point-in-time tablespace recovery

RMAN-05003: point-in-time recovery is not allowed for tablespace string

RMAN-05004: target database log mode is NOARCHIVELOG

RMAN-05005: point-in-time recovery is not allowed for re-created tablespace string

RMAN-05006: cannot recover clone standby single tablespaces

RMAN-05007: no channel allocated

RMAN-05008: SET NEWNAME TO NEW not allowed (datafile string)

RMAN-05009: Block Media Recovery requires Enterprise Edition

RMAN-05010: target database must be opened in READ WRITE mode for TSPITR

RMAN-05011: auxiliary instance must be in nomount state for TSPITR

RMAN-05012: trying to start the Oracle instance without parameter files ...

RMAN-05013: auxiliary control filename string conflicts with a file used by the target database

RMAN-05014: tablespaces with undo segments were not found in recovery catalog

RMAN-05015: WARNING: not enough information in recovery catalog for specified point in time recovery

RMAN-05016: failover to previous backup

RMAN-05017: no copy of datafile number found to recover

RMAN-05018: some datafile copies cannot be recovered, aborting the RECOVER command

RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile number

RMAN-05020: cannot specify AUXILIARY DESTINATION option for normal recovery

RMAN-05021: this configuration cannot be changed for a BACKUP or STANDBY control file

RMAN-05022: TRANSPORT TABLESPACE may not be used with user-managed auxiliary instance

RMAN-05023: TABLESPACE DESTINATION required

RMAN-05024: List of tablespaces presumed to have UNDO segments

RMAN-05025: tablespace string

RMAN-05026: WARNING: presuming following set of tablespaces applies to specified point in time

RMAN-05027: List of tablespaces expected to have UNDO segments

RMAN-05028: tablespace string

RMAN-05029: UNDO TABLESPACE clause is only valid for Tablespace Point-in-Time Recovery

RMAN-05030: CLONE clause cannot be used with Tablespace Point-in-Time Recovery

RMAN-05031: cannot specify UNDO TABLESPACES clause for normal recovery

RMAN-05032: data file string will be created automatically during restore operation

RMAN-05033: Media recovery start SCN is string

RMAN-05034: Recovery must be done beyond SCN string to clear data files fuzziness

RMAN-05035: archive logs generated after SCN string not found in repository

RMAN-05040: List of tablespaces that have been dropped from the target database:

RMAN-05041: Error during export of metadata

RMAN-05042: Error during import of metadata

RMAN-05043: tablespace string

RMAN-05044: Performing export of metadata...

RMAN-05045: Performing import of metadata...

RMAN-05046: Export completed

RMAN-05047: Import completed

RMAN-05048: specified filename string conflicts with a file used by the target database

RMAN-05049: datafile string is an Oracle Managed File, DB_CREATE_FILE_DEST not set at target

RMAN-05500: the auxiliary database must be not mounted when issuing a DUPLICATE command

RMAN-05501: aborting duplication of target database

RMAN-05502: the target database must be mounted when issuing a DUPLICATE command

RMAN-05503: at least one auxiliary channel must be allocated to execute this command

RMAN-05504: at least two redo log files or groups must be specified for this command

RMAN-05505: auxiliary filename conversion of "string" exceeds maximum length of string

RMAN-05506: error during recursive execution

RMAN-05507: standby control file checkpoint (string) is more recent than duplication point in time (string)

RMAN-05510: Duplicate finished

RMAN-05511: Datafile string skipped by request

RMAN-05512: tablespace string cannot be skipped from duplication

RMAN-05513: cannot duplicate, control file is not current or backup

RMAN-05514: tablespace string has undo information, cannnot skip

RMAN-05515: Duplicate for standby does not allow the use of SET UNTIL

RMAN-05516: duplicate operand specified: string

RMAN-05517: temporary file string conflicts with file used by target database

RMAN-05520: database name mismatch, auxiliary instance has string, command specified string

RMAN-06000: could not open recovery manager library file: string

RMAN-06001: error parsing job step library

RMAN-06002: command not allowed when not connected to a recovery catalog

RMAN-06003: ORACLE error from target database: string

RMAN-06004: ORACLE error from recovery catalog database: string

RMAN-06005: connected to target database: string (DBID=string)

RMAN-06006: connected to target database: string (not mounted)

RMAN-06007: target database not mounted and db_name not set in init.ora

RMAN-06008: connected to recovery catalog database

RMAN-06009: using target database control file instead of recovery catalog

RMAN-06010: error while looking up datafile: string

RMAN-06011: invalid level specified: number

RMAN-06012: channel: string not allocated

RMAN-06013: duplicate channel identifier found: string

RMAN-06014: command not implemented yet: string

RMAN-06015: error while looking up datafile copy name: string

RMAN-06016: duplicate backup operand specified: string

RMAN-06017: initialization of parser failed

RMAN-06018: duplicate operand specified in backup specification: string

RMAN-06019: could not translate tablespace name "string"

RMAN-06020: connected to auxiliary database (not started)

RMAN-06021: FROM DATAFILECCOPY/BACKUPSET may not be specified with archive logs

RMAN-06022: invalid level specified for image copy: number

RMAN-06023: no backup or copy of datafile number found to restore

RMAN-06024: no backup or copy of the control file found to restore

RMAN-06025: no backup of log thread number seq number lowscn string found to restore

RMAN-06026: some targets not found - aborting restore

RMAN-06027: no archive logs found that match specification

RMAN-06028: duplicate operand specified in restore specification: string

RMAN-06029: the control file may be included only in a datafile backup set

RMAN-06030: the DELETE [ALL] INPUT option may not be used with a datafile backup set

RMAN-06031: could not translate database keyword

RMAN-06032: at least 1 channel of TYPE DISK must be allocated to execute a COPY command

RMAN-06033: channel string not allocated

RMAN-06034: at least 1 channel must be allocated to execute this command

RMAN-06035: wrong version of recover.bsq, expecting string, found string

RMAN-06036: datafile number is already restored to file string

RMAN-06038: recovery catalog package detected an error

RMAN-06039: no set newname command has been issued for datafile number

RMAN-06040: control file is already restored to file string

RMAN-06041: cannot switch file number to copy of file number

RMAN-06042: PLUS ARCHIVELOG option is not supported with non-datafile backups

RMAN-06043: TAG option not supported for archive log copies

RMAN-06045: LEVEL option not supported for archive log or current/standby control file copies

RMAN-06046: archive log name: string

RMAN-06047: duplicate datafile number specified for restoration from copy

RMAN-06048: duplicate control file specified for restoration from copy

RMAN-06049: CHECK LOGICAL option not supported for archive log or current/standby control file copies

RMAN-06050: archive log thread number sequence number is already on disk as file string

RMAN-06051: DELETE INPUT option not implemented yet

RMAN-06052: no parent backup or copy of datafile number found

RMAN-06053: unable to perform media recovery because of missing log

RMAN-06054: media recovery requesting unknown log: thread string seq string lowscn string

RMAN-06055: could not find log sequence string thread string

RMAN-06056: could not access datafile number

RMAN-06057: a standby control file cannot be included along with a current control file

RMAN-06058: a current control file cannot be included along with a standby control file

RMAN-06059: expected archived log not found, lost of archived log compromises recoverability

RMAN-06060: WARNING: skipping datafile compromises tablespace string recoverability

RMAN-06061: WARNING: skipping archivelog compromises recoverability

RMAN-06062: can not backup SPFILE because the instance was not started with SPFILE

RMAN-06063: DBID is not found in the recovery catalog

RMAN-06064: creating datafile fno=string name=string

RMAN-06065: The backup operand [string] conflicts with another specified operand.

RMAN-06066: the target database must be mounted when issuing a RECOVER command

RMAN-06067: RECOVER DATABASE required with a backup or created control file

RMAN-06068: recovery aborted because of missing datafiles

RMAN-06069: the filename for datafile string is missing in the control file

RMAN-06070: DBWR could not identify datafile string

RMAN-06071: could not open datafile string

RMAN-06073: file header is corrupt for datafile string

RMAN-06074: file string is not an ORACLE datafile

RMAN-06075: datafile string does not belong to this database

RMAN-06076: datafile string contains wrong datafile

RMAN-06077: datafile string is a different version than contained in the control file

RMAN-06078: the control file is older than datafile string

RMAN-06079: database must be mounted to perform recovery

RMAN-06080: SWITCH required for datafile string

RMAN-06081: error reading datafile header for datafile string, code string

RMAN-06082: datafile copy tag string is ambiguous

RMAN-06083: error when loading stored script string

RMAN-06084: the target database may not be mounted when issuing REPLICATE

RMAN-06085: must use SET NEWNAME command to restore datafile string

RMAN-06086: offline files may only be skipped in a datafile backup set

RMAN-06087: read-only files may only be skipped in a datafile backup set

RMAN-06088: datafile copy string not found or out of sync with catalog

RMAN-06089: archived log string not found or out of sync with catalog

RMAN-06090: error while looking up control file copy: string

RMAN-06091: no channel allocated for maintenance (of an appropriate type)

RMAN-06092: error while looking up backup piece

RMAN-06093: recovery catalog contains obsolete version of datafile string

RMAN-06094: datafile string must be restored

RMAN-06095: a backup control file must be restored to recover datafile string

RMAN-06096: SWITCH required for newname of datafile string to take effect

RMAN-06098: the target database must be mounted when issuing a BACKUP command

RMAN-06099: error occurred in source file: string, line: number

RMAN-06100: no channel to restore a backup or copy of datafile number

RMAN-06101: no channel to restore a backup or copy of the control file

RMAN-06102: no channel to restore a backup or copy of log thread number seq number lowscn string

RMAN-06103: duplicate qualifier found in REPORT command: string

RMAN-06105: duplicate qualifier found in LIST command: string

RMAN-06106: this command requires that target database be mounted

RMAN-06107: WARNING: control file is not current for REPORT NEED BACKUP DAYS

RMAN-06108: changed datafile copy unvailable

RMAN-06109: changed archive log unavailable

RMAN-06110: changed control file copy unavailable

RMAN-06111: changed backup piece unavailable

RMAN-06112: changed datafile copy available

RMAN-06113: changed archive log available

RMAN-06114: changed control file copy available

RMAN-06115: changed backup piece available

RMAN-06116: cannot crosscheck unavailable object

RMAN-06117: cannot do DELETE EXPIRED on an object which is not expired

RMAN-06118: a backup control file older than SCN string must be used for this recovery

RMAN-06119: uncataloged datafile copy

RMAN-06120: uncataloged archive log

RMAN-06121: uncataloged control file copy

RMAN-06122: CHANGE .. UNCATALOG not supported for BACKUPSET

RMAN-06123: operation not supported without the recovery catalog or mounted control file

RMAN-06124: error while looking up datafile copy key: number

RMAN-06125: error while looking up archive log key: number

RMAN-06126: skipping offline file string

RMAN-06127: skipping read-only file string

RMAN-06128: skipping inaccessible file string

RMAN-06129: invalid reserved channel ID: string

RMAN-06131: skip offline/readonly only allowed with current control file

RMAN-06132: cannot backup datafile string because it is not in the control file

RMAN-06133: recovery catalog may have obsolete data for datafile string

RMAN-06134: host command complete

RMAN-06135: error executing host command: string

RMAN-06136: ORACLE error from auxiliary database: string

RMAN-06137: must have recovery catalog for REPORT SCHEMA AT TIME

RMAN-06138: control file not mounted - must specify AT clause with REPORT command

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA

RMAN-06140: cannot specify TAG option with LIST INCARNATION

RMAN-06141: cannot specify ARCHIVELOG LIKE option with RESTORE

RMAN-06142: DEVICE TYPE cannot be specified with this command

RMAN-06143: LIKE may only be specified with COPY

RMAN-06144: FROM or UNTIL may not be specified with LIST INCARNATION

RMAN-06145: control file is not current - obsolete file list may be incomplete

RMAN-06146: changes found for file number beyond offline SCN

RMAN-06147: no obsolete backups found

RMAN-06148: redundancy count must be greater than zero

RMAN-06150: auxiliary name for datafile number set to: string

RMAN-06151: datafile string creation scn string

RMAN-06153: validation failed for datafile copy

RMAN-06154: validation succeeded for datafile copy

RMAN-06155: validation failed for control file copy

RMAN-06156: validation succeeded for control file copy

RMAN-06157: validation failed for archived log

RMAN-06158: validation succeeded for archived log

RMAN-06159: error while looking up backup set

RMAN-06160: no backup pieces found for backup set key: number

RMAN-06161: error when inspecting auxiliary filename: string

RMAN-06162: sql statement: string

RMAN-06163: some datafiles cannot be recovered, aborting the RECOVER command

RMAN-06164: WARNING: no channel of required type allocated to recover datafile number

RMAN-06165: datafile string is too old to recover, restore a more recent copy

RMAN-06166: datafile string cannot be recovered

RMAN-06167: already connected

RMAN-06168: no backup pieces with this tag found: string

RMAN-06169: could not read file header for datafile string error reason string

RMAN-06170: no control file copy found with offline range recid string stamp string datafile string

RMAN-06171: not connected to target database

RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

RMAN-06173: no set newname command has been issued for datafile string when restore auxiliary

RMAN-06174: not connected to auxiliary database

RMAN-06175: deleted script: string

RMAN-06176: no recovery required; all files are readonly or offline

RMAN-06177: restore not done; all files readonly, offline, or already restored

RMAN-06178: datafile number not processed because file is offline

RMAN-06179: datafile number not processed because file is read-only

RMAN-06180: incremental backups require Enterprise Edition

RMAN-06181: multiple channels require Enterprise Edition

RMAN-06182: archive log larger than MAXSETSIZE: thread string seq string string

RMAN-06183: datafile or datafile copy larger than MAXSETSIZE: file# string string

RMAN-06184: duplicate object in backup specifier: string string

RMAN-06185: Recovery Manager incompatible with string database: RMAN number.number.number.number to number.number.number.number required

RMAN-06186: PL/SQL package string.string version string in string database is too old

RMAN-06187: control file copy string not found or out of sync with catalog

RMAN-06188: cannot use command when connected to a mounted target database

RMAN-06189: current DBID number does not match target mounted database (number)

RMAN-06190: PL/SQL package string.string version string in string database is not current

RMAN-06191: PL/SQL package string.string version string in string database is too new

RMAN-06192: maximum value for MAXPIECESIZE or MAXSETSIZE must be between 1 Kb and 2048 Gb

RMAN-06193: connected to target database (not started)

RMAN-06194: target database instance not started

RMAN-06195: auxiliary database not started

RMAN-06196: Oracle instance started

RMAN-06197: Total System Global Area string bytes

RMAN-06198: %-24s string bytes

RMAN-06199: database mounted

RMAN-06200: Changed string objects to AVAILABLE status

RMAN-06201: Deleted string objects

RMAN-06202: Deleted string EXPIRED objects

RMAN-06203: Changed KEEP options for string objects

RMAN-06204: Changed string objects to UNAVAILABLE status

RMAN-06205: Uncataloged string objects

RMAN-06206: Crosschecked string objects

RMAN-06207: WARNING: string objects could not be deleted for string channel(s) due

RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status

RMAN-06209: List of failed objects

RMAN-06210: List of Mismatched objects

RMAN-06211: ==========================

RMAN-06212: Object Type Filename/Handle

RMAN-06213: --------------- ---------------------------------------------------

RMAN-06214: %-15s string

RMAN-06220: Creating automatic instance, with SID="string"

RMAN-06221: Removing automatic instance

RMAN-06223: starting up automatic instance string

RMAN-06224: Automatic instance created

RMAN-06225: shutting down automatic instance string

RMAN-06226: Automatic instance removed

RMAN-06230: List of Stored Scripts in Recovery Catalog

RMAN-06246: List of Database Incarnations

RMAN-06250: Report of files that need backup due to unrecoverable operations

RMAN-06263: %-4s string string

RMAN-06270: Report of files whose recovery needs more than number days of archived logs

RMAN-06274: Report of files that must be backed up to satisfy number days recovery window

RMAN-06275: invalid number of days specified for report : string days

RMAN-06280: Report of obsolete backups and copies

RMAN-06290: Report of database schema

RMAN-06300: Report of files with less than number redundant backups

RMAN-06306: ====================

RMAN-06378: List of Backup Sets

RMAN-06400: database opened

RMAN-06401: database is already started

RMAN-06402: Oracle instance shut down

RMAN-06403: could not obtain a fully authorized session

RMAN-06404: database dismounted

RMAN-06405: database closed

RMAN-06406: deleted archive log

RMAN-06407: auxiliary instance file string deleted

RMAN-06408: recovery catalog upgraded to version string

RMAN-06409: LIKE clause in LIST BACKUP OF ARCHIVELOG is not supported

RMAN-06410: cannot use command when channels are allocated

RMAN-06411: backup copies setting out of range (1-4): number

RMAN-06412: no proxy copy channel found

RMAN-06413: channel string does not support proxy copy

RMAN-06414: target database COMPATIBLE option does not support proxy copy

RMAN-06415: file string cannot be proxy backed up

RMAN-06416: PROXY ONLY was specified and some files could not be proxy copied

RMAN-06418: proxy incremental backups with level > 0 not supported

RMAN-06419: file string cannot be proxy restored from handle string

RMAN-06420: some files could not be proxy restored - aborting restore

RMAN-06421: sent command to channel: string

RMAN-06422: no channels found for SEND command

RMAN-06423: requested limit of number exceeds vendor limit of number

RMAN-06424: error while looking up proxy copy

RMAN-06425: <datafile pathname not available>

RMAN-06426: RECOVERY_CATALOG_OWNER role must be granted to user string

RMAN-06427: recovery catalog already exists

RMAN-06428: recovery catalog is not installed

RMAN-06429: %s database is not compatible with this version of RMAN

RMAN-06430: recovery catalog userid cannot be SYS

RMAN-06431: recovery catalog created

RMAN-06432: recovery catalog dropped

RMAN-06433: error installing recovery catalog

RMAN-06434: some errors occurred while removing recovery catalog

RMAN-06435: recovery catalog owner is string

RMAN-06436: enter DROP CATALOG command again to confirm catalog removal

RMAN-06437: cannot drop catalog - catalog is newer than this RMAN

RMAN-06438: error executing package DBMS_RCVMAN in string database

RMAN-06439: RMAN must be upgraded to version string to work with this package

RMAN-06441: cannot upgrade catalog - catalog is already newer than this RMAN

RMAN-06442: enter UPGRADE CATALOG command again to confirm catalog upgrade

RMAN-06443: error upgrading recovery catalog

RMAN-06444: %s created with compilation errors

RMAN-06445: cannot connect to recovery catalog after NOCATALOG has been used

RMAN-06446: changed proxy copy unavailable

RMAN-06447: changed proxy copy available

RMAN-06448: uncataloged proxy copy

RMAN-06449: deleted proxy copy

RMAN-06450: crosschecked proxy copy: found to be "string"

RMAN-06451: proxy copy handle=string recid=string stamp=string

RMAN-06452: %s package upgraded to version string

RMAN-06453: RECOVERABLE may only be used with datafile objects

RMAN-06454: duplexed backups require Enterprise Edition

RMAN-06455: point-in-time tablespace recovery requires Enterprise Edition

RMAN-06456: command is obsolete

RMAN-06457: UNTIL scn (string) is ahead of last scn in archived logs (string)

RMAN-06458: AS COPY option cannot be used with RECOVERY FILES, RECOVERY AREA or DB_RECOVERY_FILE_DEST

RMAN-06459: BACKUP <VALIDATE|DURATION> is not supported with PROXY

RMAN-06460: control cile copy string cannot be backed up by proxy.

RMAN-06461: current control file cannot be backed up by proxy.

RMAN-06462: no backupsets found on device DISK that match specification

RMAN-06463: Backup set key string cannot be backed up by proxy.

RMAN-06464: BACKUP BACKUPSET is not supported with VALIDATE option

RMAN-06465: configuration not implemented: string

RMAN-06466: error parsing configuration string (string)

RMAN-06467: could not translate DBA: number

RMAN-06468: Invalid Data Block Address: number

RMAN-06469: could not translate corruption list

RMAN-06470: DEVICE TYPE is supported only when automatic channels are used

RMAN-06471: no configuration found to allocate channels for string

RMAN-06472: channel id string is automatically allocated

RMAN-06474: maintenance channels are not allocated

RMAN-06475: parallelism setting out of range (1-254): number

RMAN-06476: channel number out of range (1-254): number

RMAN-06477: configuration value length exceeds 1024

RMAN-06478: WARNING: datafile copy "string" cannot be found on disk

RMAN-06479: WARNING: control file copy "string" cannot be found on disk

RMAN-06480: WARNING: archivelog "string" cannot be found on disk

RMAN-06481: WARNING: backup piece "string" cannot be found on the storage medium

RMAN-06482: WARNING: proxy copy "string" cannot be found on the storage medium

RMAN-06483: changed datafile copy expired

RMAN-06484: changed control file copy expired

RMAN-06485: changed archivelog expired

RMAN-06486: changed backup piece expired

RMAN-06487: changed proxy copy expired

RMAN-06488: restore from autobackup does not allow any other modifiers

RMAN-06489: no configuration found to allocate clone channel number for device type string

RMAN-06490: WARNING: limit of autobackups for the day has been reached

RMAN-06491: controlfile autobackup format "string" contains more than one "string" format specifier

RMAN-06492: controlfile autobackup format "string" must specify a "string" format specifier

RMAN-06493: only UNTIL TIME clause is allowed when performing a restore from autobackup, found: string

RMAN-06494: %s = string is out of range (string-string)

RMAN-06495: must explicitly specify DBID with SET DBID command

RMAN-06496: must use the TO clause when the database is mounted or open

RMAN-06497: WARNING: control file is not current, control file autobackup skipped

RMAN-06498: skipping datafile string; already backed up string time(s)

RMAN-06499: skipping archive log file string; already backed up string time(s)

RMAN-06500: skipping backupset key string; already backed up string time(s)

RMAN-06501: skipping datafile string; already backed up on string

RMAN-06502: skipping archive log file string; already backed on string

RMAN-06503: skipping backupset key string; already backed up on string

RMAN-06504: PROXY option with multiple backup copies is not supported

RMAN-06506: the MAXSETSIZE option cannot be used with a backup backupset

RMAN-06507: trying alternate file for archivelog thread number, sequence number

RMAN-06508: MAXSETSIZE string kbytes should be greater than blocksize string bytes

RMAN-06509: only SPFILE or control file can be restored from autobackup

RMAN-06510: RMAN retention policy is set to recovery window of number days

RMAN-06511: RMAN retention policy is set to redundancy number

RMAN-06512: copy will be obsolete on date string

RMAN-06513: copy will never be obsolete

RMAN-06514: archived logs required to recover from this copy will not be kept

RMAN-06515: archived logs required to recover from this copy will expire when this copy expires

RMAN-06516: time specified in KEEP UNTIL clause must be be after today

RMAN-06517: KEEP option is not supported for archive log backups

RMAN-06518: backup will be obsolete on date string

RMAN-06519: backup will never be obsolete

RMAN-06520: archived logs required to recover from this backup will not be kept

RMAN-06521: archived logs required to recover from this backup will expire when this backup expires

RMAN-06522: KEEP FOREVER option is not supported without the recovery catalog

RMAN-06524: RMAN retention policy will be applied to the command

RMAN-06525: RMAN retention policy is set to none

RMAN-06526: KEEP option cannot be used with incremental backup

RMAN-06527: KEEP option is not supported for backup of backup sets

RMAN-06528: CHANGE ... KEEP not supported for BACKUPPIECE

RMAN-06529: CHANGE ... KEEP not supported for ARCHIVELOG

RMAN-06530: CHANGE ... KEEP not supported for backup set which contains archive logs

RMAN-06531: CHANGE ... KEEP not supported for incremental BACKUPSET

RMAN-06532: redundancy count must be greater than zero

RMAN-06533: KEEP ... NOLOGS option cannot be used when datafiles are fuzzy

RMAN-06534: KEEP ... CONSISTENT option is not supported

RMAN-06535: LIST COPY OF SPFILE is not supported

RMAN-06536: BACKED UP ... TIMES option is supported only for archived logs

RMAN-06537: CHANGE ... KEEP not supported for BACKUP

RMAN-06540: tablespace string will be excluded from future whole database backups

RMAN-06541: tablespace string will be included in future whole database backups

RMAN-06542: file string is excluded from whole database backup

RMAN-06543: duplicate or conflicting LIST options: string and string

RMAN-06544: Do you really want to delete the above objects (enter YES or NO)?

RMAN-06545: "string" is an invalid response - please re-enter.

RMAN-06546: Error occurred getting response - assuming NO response

RMAN-06547: tablespace SYSTEM cannot be excluded from whole database backup

RMAN-06548: connected to auxiliary database: string (DBID=string)

RMAN-06549: connected to auxiliary database: string (not mounted)

RMAN-06550: clone database not mounted and db_name not set in init.ora

RMAN-06551: error while looking up datafile copy for file number: string

RMAN-06552: newname for datafile number was set to NEW, but file was not restored

RMAN-06553: DB_CREATE_FILE_DEST must be set for SET NEWNAME ... TO NEW

RMAN-06554: WARNING: file string is in backup mode

RMAN-06555: datafile string must be restored from backup created before string

RMAN-06556: datafile string must be restored from backup older than scn string

RMAN-06557: unable to restore archived log thread number, sequence number

RMAN-06558: archived log size of number kb is bigger than available space of number kb

RMAN-06559: MAXSIZE must be larger than 1 kb

RMAN-06560: WARNING: backup set with key number will be read number times

RMAN-06561: available space must be larger than number kb

RMAN-06562: available space of number kb needed to avoid reading the backup set multiple times

RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP

RMAN-06564: must use the TO clause when the instance is started with SPFILE

RMAN-06565: WARNING: string: sqlcode number was caught, automatic retry #number

RMAN-06566: target database incarnation not found in control file

RMAN-06567: connected to auxiliary database: string (DBID=string, not open)

RMAN-06568: connected to target database: string (DBID=string, not open)

RMAN-06570: datafile number switched to datafile copy "string"

RMAN-06571: datafile number does not have recoverable copy

RMAN-06572: database is open and datafile number is not offline

RMAN-06575: platform id number found in datafile string header is not a valid platform id

RMAN-06576: platform "string" (number) found in header of datafile string does not match specified platform name "string" (number)

RMAN-06577: FROM TAG option may only be used with datafilecopies

RMAN-06578: INCREMENTAL LEVEL > 0 must be specified with FOR RECOVER OF

RMAN-06580: the string option cannot be used with AS COPY

RMAN-06581: option string not supported

RMAN-06582: AS COPY option cannot be used when backing up backupsets

RMAN-06583: at least 1 channel of TYPE DISK must be allocated to use AS COPY option

RMAN-06584: WARNING: AS BACKUPSET option added due to allocation of multiple channel types

RMAN-06585: no copy of datafile number found

RMAN-06586: no copy of datafile number with tag string found

RMAN-06587: one or more datafilecopies were not found

RMAN-06588: number of patterns (number) to DB_FILE_NAME_CONVERT should be even

RMAN-06589: cannot specify DB_FILE_NAME_CONVERT option without AS COPY

RMAN-06590: tablespace string cannot be converted

RMAN-06591: must specify TO PLATFORM

RMAN-06592: must specify FROM PLATFORM

RMAN-06593: platform name "string" specified in FROM PLATFORM is not valid

RMAN-06594: platform name "string" specified in TO PLATFORM is not valid

RMAN-06595: platform name "string" does not match database platform name "string"

RMAN-06596: to use CONVERT compatibility must be set to 10.0.0 or greater, currently set to string

RMAN-06597: conversion between platforms "string" and "string" is not implemented

RMAN-06598: conversion between platforms "string" and "string" is not needed

RMAN-06599: tablespace string is not read-only

RMAN-06600: old RMAN configuration parameters:

RMAN-06601: new RMAN configuration parameters:

RMAN-06604: new RMAN configuration parameters are successfully stored

RMAN-06605: old RMAN configuration parameters are successfully deleted

RMAN-06606: RMAN configuration parameters are successfully reset to default value

RMAN-06607: RMAN configuration parameters are:

RMAN-06608: RMAN configuration has no stored or default parameters

RMAN-06609: AS COPY can be configured only for disk device

RMAN-06610: For record type string recids from number to number are re-used before resync

RMAN-06700: error parsing text script in file string

RMAN-06701: could not construct path for file: "string"

RMAN-06702: could not initialize for input file: "string"

RMAN-06703: could not open file: "string" (reason=string)

RMAN-06705: text script line is too long (>1024)

RMAN-06706: could not close file: "string" (reason=string)

RMAN-06707: could not initialize for output file: "string"

RMAN-06708: short write while writing file "string". Wrote string bytes instead of string bytes

RMAN-06709: No scripts in recovery catalog

RMAN-06710: script string not found in catalog

RMAN-06711: global scripts require a target connection

RMAN-06716: skipping datafile number; already restored to file string

RMAN-06717: number of source files (string) and destination files (string) does not match

RMAN-06718: could not find file "string" in catalog

RMAN-06719: file "string" (string bytes) restrieved from catalog

RMAN-06720: file "string" removed from catalog

RMAN-06721: could not normalize path for file: "string"

RMAN-06722: unable to remove file "string" from catalog

RMAN-06723: file "string" (string bytes) updated in catalog

RMAN-06724: backup not done; all files already backed up

RMAN-06725: database not open: sort area size too small

RMAN-06726: could not locate archivelog string

RMAN-06727: could not locate datafile copy string

RMAN-06728: could not locate control file copy string

RMAN-06729: no backup of the SPFILE found to restore

RMAN-06730: no channel to restore a backup of the SPFILE

RMAN-06731: command string:string%% complete, time left number:number:number

RMAN-06732: database dropped

RMAN-06733: database unregistered from the recovery catalog

RMAN-06734: Do you really want to drop all backups and the database (enter YES or NO)?

RMAN-06735: Do you really want to drop the database (enter YES or NO)?

RMAN-06736: Do you really want to unregister the database (enter YES or NO)?

RMAN-06737: database name "string" does not match target database name "string"

RMAN-06738: database name "string" is not unique in the recovery catalog

RMAN-06739: database "string" is not found in the recovery catalog

RMAN-06740: database name is not specified

RMAN-06741: database name is "string" and DBID is string

RMAN-06742: platform name "string" longer than number

RMAN-06743: specification does not match any backupset in the repository

RMAN-06744: specification does not match any datafile copy in the repository

RMAN-06745: skipping datafile copy string; already backed up string time(s)

RMAN-06746: backup cancelled because all files were skipped

RMAN-06747: at least 1 channel of tertiary storage must be allocated to execute this command

RMAN-06748: no or more than one tertiary storage channel found

RMAN-06749: restore point string does not exist.

RMAN-06750: SPFILE cannot be backed up by proxy.

RMAN-06751: ASM file string cannot be proxy backed up.

RMAN-06752: error while looking up temporary file: string

RMAN-06753: temporary file not found in the repository

RMAN-06754: INCREMENTAL FROM SCN option is not supported with [string]

RMAN-06755: WARNING: datafile string: incremental-start SCN is too recent; using checkpoint SCN string instead

RMAN-06756: cannot flashback database to non-guaranteed restore point string when flashback is off

RMAN-06757: DB_UNIQUE_NAME "string" does not match target database ("string")

RMAN-06758: DB_UNIQUE_NAME is not unique in the recovery catalog

RMAN-06759: skipping datafile copies that are already backed up

RMAN-06760: skipping archived logs that are already backed up

RMAN-06761: skipping backup sets that are already backed up

RMAN-06762: ignoring encryption for proxy or image copies

RMAN-06763: specified encryption algorithm not supported

RMAN-06764: %s

RMAN-06765: tablespace string will be encrypted in future backup sets

RMAN-06766: tablespace string will not be encrypted in future backup sets

RMAN-06767: tablespace string will default to database encryption configuration

RMAN-06768: duplicate or conflicting options are specified: string and string

RMAN-06769: length of password must be greater than zero

RMAN-06770: backup encryption requires Enterprise Edition

RMAN-06899: updating recovery catalog with new database incarnation

RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row

RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows

RMAN-06902: AS COMPRESSED BACKUPSET option cannot be used when backing up backupsets

RMAN-06903: backup of datafile string was cancelled

RMAN-06904: backup of log thread number seq number lowscn string was cancelled

RMAN-06905: backup of backupset key number was cancelled

RMAN-06906: backup of control file was cancelled

RMAN-06907: MINIMIZE LOAD option not allowed for the specified input files

RMAN-06908: WARNING: operation will not run in parallel on the allocated channels

RMAN-06909: WARNING: parallelism require Enterprise Edition

RMAN-06910: can not invoke parallel recovery for test recovery

RMAN-06911: only one PARALLEL or NOPARALLEL clause may be specified

RMAN-06912: backup of spfile was cancelled

RMAN-06920: database string is not open read-only

RMAN-06921: Convert database check failed

RMAN-06922: External table string.string found in the database

RMAN-06923: Directory string.string found in the database

RMAN-06924: BFILE string.string found in the database

RMAN-06925: BFILEs are used in the system, please redefine them in the transported database

RMAN-06926: User string with string privilege found in password file

RMAN-06927: Cannot specify NEW DATABASE clause more than once

RMAN-06928: Cannot specify ON TARGET PLATFORM clause more than once

RMAN-06929: Cannot specify TRANSPORT SCRIPT clause more than once

RMAN-06930: Cannot specify SKIP clause more than once

RMAN-06931: Cannot specify FROM PLATFORM clause

RMAN-06932: Database name "string" longer than number

RMAN-06933: Transport script name too long

RMAN-06934: Format string too long

RMAN-06935: Convert script name too long

RMAN-06941: Database must be closed and mounted EXCLUSIVE and RESTRICTED.

RMAN-07000: List of SPFILE Backups

RMAN-07500: searching for all files that match the pattern string

RMAN-07501: searching for all files in the recovery area

RMAN-07502: List of Files Unknown to the Database

RMAN-07505: no files found to be unknown to the database

RMAN-07506: Do you really want to catalog the above files (enter YES or NO)?

RMAN-07507: cataloging files...

RMAN-07508: cataloging done

RMAN-07509: List of Cataloged Files

RMAN-07513: List of Files Which Where Not Cataloged

RMAN-07514: =======================================

RMAN-07515: File Name: string

RMAN-07516: Reason: Error reading

RMAN-07517: Reason: The file header is corrupted

RMAN-07518: Reason: Foreign database file DBID: string Database Name: string

RMAN-07519: Reason: Error while cataloging. See alert.log.

RMAN-07520: Reason: Data pump dump file

RMAN-07521: cannot create recovery catalog in database version string; version string required

RMAN-07522: CREATE TYPE privilege must be granted to user string

RMAN-07523: List of files in Recovery Area not managed by the database

RMAN-07524: ==========================================================

RMAN-07525: Reason: File is not a supported file type in Recovery Area

RMAN-07526: Reason: File is not an Oracle Managed File

RMAN-07527: Reason: File was not created using DB_RECOVERY_FILE_DEST initialization parameter

RMAN-07528: number of files not managed by recovery area is string, totaling stringB

RMAN-07529: Reason: catalog is not supported for this file type

RMAN-08000: channel string: copied datafile string

RMAN-08001: restore not complete

RMAN-08002: starting full resync of recovery catalog

RMAN-08003: channel string: reading from backup piece string

RMAN-08004: full resync complete

RMAN-08005: new incarnation of database registered in recovery catalog

RMAN-08006: database registered in recovery catalog

RMAN-08007: channel string: copied datafile copy of datafile string

RMAN-08008: channel string: starting full datafile backupset

RMAN-08009: channel string: starting archive log backupset

RMAN-08010: channel string: specifying datafile(s) in backupset

RMAN-08011: including current control file in backupset

RMAN-08012: including control file copy in backup set

RMAN-08013: channel string: backup piece string

RMAN-08014: channel string: specifying archive log(s) in backup set

RMAN-08015: datafile string switched to datafile copy

RMAN-08016: channel string: starting datafile backupset restore

RMAN-08017: channel string: starting archive log restore to default destination

RMAN-08018: channel string: starting archive log restore to user-specified destination

RMAN-08019: channel string: restoring datafile string

RMAN-08020: including standby control file in backupset

RMAN-08021: channel string: restoring control file

RMAN-08022: channel string: restoring archive log

RMAN-08023: channel string: restored backup piece string

RMAN-08025: channel string: copied control file copy

RMAN-08026: channel string: copied archive log

RMAN-08027: channel string: copied current control file

RMAN-08028: channel string: copy current control file failed

RMAN-08029: snapshot control file name set to default value: string

RMAN-08030: allocated channel: string

RMAN-08031: released channel: string

RMAN-08032: channel string: recid string stamp string does not match recovery catalog

RMAN-08033: channel string: including datafile copy of datafile string in backupset

RMAN-08034: full resync skipped, target database not mounted

RMAN-08035: partial resync skipped, target database not mounted

RMAN-08036: channel string: could not create control file record for string string

RMAN-08037: channel string: unexpected validation return code string

RMAN-08038: channel string: starting piece string at string

RMAN-08039: channel string: starting incremental datafile backupset restore

RMAN-08040: full resync skipped, control file is not current or backup

RMAN-08041: partial resync skipped, control file is not current or backup

RMAN-08042: channel string: copied standby control file

RMAN-08043: channel string: copy standby control file failed

RMAN-08044: channel string: finished piece string at string

RMAN-08045: channel string: finished piece string at string with string copies

RMAN-08046: channel string: starting compressed full datafile backupset

RMAN-08047: channel string: starting compressed incremental level string datafile backupset

RMAN-08048: channel string: starting incremental level string datafile backupset

RMAN-08049: channel string: starting compressed archive log backupset

RMAN-08050: cataloged datafile copy

RMAN-08051: cataloged archive log

RMAN-08052: cataloged control file copy

RMAN-08053: channel string: finished piece string at string with string copies and tag string

RMAN-08054: starting media recovery

RMAN-08056: skipping datafile string because it has not changed

RMAN-08057: channel string: backup cancelled because all files were skipped

RMAN-08058: replicating control file

RMAN-08059: media recovery failed

RMAN-08060: unable to find archive log

RMAN-08066: database reset to incarnation string

RMAN-08070: deleted datafile copy

RMAN-08071: channel string: deleting archive log(s)

RMAN-08072: deleted control file copy

RMAN-08073: deleted backup piece

RMAN-08074: crosschecked backup piece: found to be "string"

RMAN-08085: created script string

RMAN-08086: replaced script string

RMAN-08087: channel string: started backup set validation

RMAN-08088: applied offline range to datafile string

RMAN-08089: channel string: specifying datafile(s) to restore from backup set

RMAN-08090: channel string: starting proxy restore

RMAN-08091: channel string: specifying datafile(s) for proxy backup

RMAN-08092: channel string: specifying datafile copy of datafile string for proxy backup

RMAN-08093: specifying current control file for proxy backup

RMAN-08094: channel string: specifying datafile(s) for proxy restore

RMAN-08096: channel string: starting validation of datafile backupset

RMAN-08097: channel string: starting validation of archive log backupset

RMAN-08099: specifying standby control file for proxy backup

RMAN-08100: channel string: starting proxy validation

RMAN-08101: channel string: proxy validation complete

RMAN-08102: channel string: located backup piece: string

RMAN-08103: channel string: could not locate backup piece: string

RMAN-08104: input backupset count=string stamp=string creation_time=string

RMAN-08105: channel string: backup cancelled because no pieces were found

RMAN-08106: channel string: restoring block(s)

RMAN-08108: channel string: specifying block(s) to restore from backup set

RMAN-08109: channel string: restored block(s) from backup piece string

RMAN-08110: failover to next copy of backuppiece

RMAN-08111: some blocks not recovered: See trace file for details

RMAN-08112: archivelog failover was done on string, check alert log for more info

RMAN-08113: including current SPFILE in backupset

RMAN-08114: channel string: restoring SPFILE to PFILE

RMAN-08115: channel string: restoring SPFILE

RMAN-08116: output filename is original SPFILE location

RMAN-08117: channel string: the autobackup does not contain an SPFILE

RMAN-08118: WARNING: could not delete the following archived redo log

RMAN-08119: skipping backup piece handle string; already exists

RMAN-08120: WARNING: archive log not deleted, not yet applied by standby

RMAN-08121: keep attributes for the backup are deleted

RMAN-08122: keep attributes for the backup are changed

RMAN-08123: keep attributes for the datafile/control file copy are deleted

RMAN-08124: keep attributes for the datafile/control file copy are changed

RMAN-08125: keep attributes for the proxy copy are deleted

RMAN-08126: keep attributes for the proxy copy are changed

RMAN-08127: cataloged backuppiece

RMAN-08128: uncataloged backuppiece

RMAN-08129: failover to piece handle=string tag=string

RMAN-08130: failover to copy on device type string

RMAN-08131: channel string: specifying datafile copies to recover

RMAN-08132: WARNING: cannot update recovery area reclaimable file list

RMAN-08133: channel string: the autobackup does not contain a standby control file.

RMAN-08135: some corrupt blocks found during conversion of file string

RMAN-08136: channel string: deleting incremental backup(s)

RMAN-08137: WARNING: archive log not deleted as it is still needed

RMAN-08150: created global script string

RMAN-08151: replaced global script string

RMAN-08152: global script string written to file string

RMAN-08153: deleted global script: string

RMAN-08154: deleted script: string

RMAN-08155: printing stored global script: string

RMAN-08156: printing stored script: string

RMAN-08157: script string written to file string

RMAN-08158: executing script: string

RMAN-08159: executing global script: string

RMAN-08160: script commands will be loaded from file string

RMAN-08161: contents of Memory Script:

RMAN-08162: executing Memory Script

RMAN-08180: channel string: restore complete, elapsed time: string

RMAN-08181: media recovery complete, elapsed time: string

RMAN-08182: channel string: validation complete, elapsed time: string

RMAN-08183: channel string: block restore complete, elapsed time: string

RMAN-08184: added temporary file string to tablespace string in control file

RMAN-08185: renamed temporary file string to string in control file

RMAN-08186: temporary file string size altered in control file

RMAN-08190: validate found one or more corrupt blocks, see trace file for details

RMAN-08300: Run SQL script string on the target platform to create database

RMAN-08301: Edit init.ora file string. This PFILE will be used to create the database on the target platform

RMAN-08302: Run RMAN script string on target platform to convert datafiles

RMAN-08303: To recompile all PL/SQL modules, run utlirp.sql and utlrp.sql on the target platform

RMAN-08304: To change the internal database identifier, use DBNEWID Utility

RMAN-08305: channel string: starting to check datafiles

RMAN-08306: channel string: datafile checking complete, elapsed time: string

RMAN-08500: channel string: sid=string devtype=string

RMAN-08501: output filename=string recid=string stamp=string

RMAN-08503: piece handle=string comment=string

RMAN-08504: input archive log thread=string sequence=string recid=string stamp=string

RMAN-08505: output filename=string

RMAN-08506: input filename=string

RMAN-08507: input datafile copy recid=string stamp=string filename=string

RMAN-08508: archive log destination=string

RMAN-08509: destination for restore of datafile string: string

RMAN-08510: archive log thread=string sequence=string

RMAN-08511: piece handle=string tag=string

RMAN-08512: waiting for snapshot control file enqueue

RMAN-08513: datafile copy filename=string recid=string stamp=string

RMAN-08514: archive log filename=string recid=string stamp=string

RMAN-08515: archive log filename=string thread=string sequence=string

RMAN-08516: control file copy filename=string recid=string stamp=string

RMAN-08517: backup piece handle=string recid=string stamp=string

RMAN-08518: channel string: scanning control file copy string

RMAN-08519: channel string: scanning datafile copy string

RMAN-08520: channel string: scanning archive log string

RMAN-08521: offline range recid=string stamp=string

RMAN-08522: input datafile fno=string name=string

RMAN-08523: restoring datafile string to string

RMAN-08524: input control file copy name=string

RMAN-08526: channel string: string

RMAN-08527: channel string: starting string proxy datafile backup at string

RMAN-08528: channel string: proxy copy complete, elapsed time: string

RMAN-08529: proxy file handle=string

RMAN-08530: piece handle=string tag=string comment=string

RMAN-08531: channel string: proxy copy string is string in media management catalog

RMAN-08532: channel string: restoring block(s) from datafile copy string

RMAN-08533: restoring blocks of datafile string

RMAN-08534: channel string: control file restore from autobackup complete

RMAN-08535: channel string: looking for autobackup on day: string

RMAN-08536: channel string: autobackup found: string

RMAN-08537: channel string: skipped, autobackup already found

RMAN-08538: channel string: no autobackup in string days found

RMAN-08539: backup set key=string recid=string stamp=string

RMAN-08540: channel string: backup set complete, elapsed time: string

RMAN-08541: channel string: SPFILE restore from autobackup complete

RMAN-08542: channel string: starting proxy archivelog backup at string

RMAN-08543: channel string: specifying archivelog(s) for proxy backup

RMAN-08544: channel string: specifying archivelog(s) for proxy restore

RMAN-08545: flashback command failed: See trace file for details

RMAN-08546: channel string: autobackup found in the recovery area

RMAN-08547: channel string: no autobackups found in the recovery area

RMAN-08548: recovery area destination: string

RMAN-08549: database name (or database unique name) used for search: string

RMAN-08550: autobackup search outside recovery area not attempted because DBID was not set

RMAN-08551: recovering datafile copy fno=string name=string

RMAN-08552: backup and output file names are identical: string

RMAN-08580: channel string: starting datafile copy

RMAN-08581: channel string: datafile copy complete, elapsed time: string

RMAN-08582: channel string: starting archive copy

RMAN-08583: channel string: archivelog copy complete, elapsed time: string

RMAN-08584: copying current control file

RMAN-08585: copying standby control file

RMAN-08586: output filename=string tag=string recid=string stamp=string

RMAN-08587: input is copy of datafile string: string

RMAN-08588: converted datafile=string

RMAN-08589: channel string: starting datafile conversion

RMAN-08590: channel string: datafile conversion complete, elapsed time: string

RMAN-08591: WARNING: invalid archivelog deletion policy

RMAN-08599: channel string: throttle time: string

RMAN-08600: ASM diskgroup to search: string

RMAN-08601: channel string: autobackup found in ASM diskgroup string

RMAN-08602: channel string: no autobackups found in ASM diskgroup string

RMAN-08603: skipping string; file in use by another process

RMAN-08604: skipping string; file deleted from recovery area to reclaim disk space

RMAN-08605: channel string: sid=string instance=string devtype=string

RMAN-08606: WARNING: The change tracking file is invalid.

RMAN-08607: List of remote backup files

RMAN-08608: Initiated recall for the following list of remote backup files

RMAN-08609: channel string: starting incremental datafile backupset

RMAN-08610: channel string: restoring datafile string to string

RMAN-08611: channel string: piece handle=string tag=string

RMAN-08612: channel string: failover to previous backup

RMAN-10000: error parsing target database connect string "string"

RMAN-10001: error parsing recovery catalog connect string "string"

RMAN-10002: ORACLE error: string

RMAN-10003: unable to connect to target database

RMAN-10004: unable to connect to recovery catalog

RMAN-10005: error opening cursor

RMAN-10006: error running SQL statement: string

RMAN-10007: error closing cursor

RMAN-10008: could not create channel context

RMAN-10009: error logging off of Oracle

RMAN-10010: error while checking for RPC completion

RMAN-10011: synchronization error while polling for rpc number, action=string

RMAN-10012: KGU error: string

RMAN-10013: error initializing PL/SQL

RMAN-10014: PL/SQL error number on line number column number: string

RMAN-10015: error compiling PL/SQL program

RMAN-10018: error cleaning up channel context

RMAN-10020: error initializing Recovery Manager execution layer

RMAN-10022: error in system-dependant sleep routine

RMAN-10023: RPC attempted to unrecognized package

RMAN-10024: error setting up for rpc polling

RMAN-10025: connection is already registered for events

RMAN-10026: network error number-number occurred registering connection

RMAN-10027: could not locate network layer context

RMAN-10028: network error number-number occurred during remote RPC

RMAN-10029: unexpected return code number from PL/SQL execution

RMAN-10030: RPC call appears to have failed to start on channel string

RMAN-10031: RPC Error: ORA-number occurred during call to string.string

RMAN-10032: unhandled exception during execution of job step number: string

RMAN-10033: error during compilation of job step number: string

RMAN-10034: unhandled exception during execution of job step number, error unknown

RMAN-10035: exception raised in RPC: string

RMAN-10036: RPC call ok on channel string

RMAN-10037: RPC anomaly detected on channel string, upinblt=number

RMAN-10038: database session for channel string terminated unexpectedly

RMAN-10039: error encountered while polling for RPC completion on channel string

RMAN-10040: asynchronous support not detected, RMAN will run synchronously

RMAN-10041: Could not re-create polling channel context following failure.

RMAN-11000: message number number not found in recovery manager message file

RMAN-11001: Oracle Error: string

RMAN-11002: could not open a cursor to the target database

RMAN-11003: failure during parse/execution of SQL statement: string

RMAN-11004: format requires %%c when duplexing

RMAN-11005: conflicting media information for piece "string"

RMAN-11006: WARNING: test recovery results: string

RMAN-12000: execution layer initialization failed

RMAN-12001: could not open channel string

RMAN-12005: error during channel cleanup

RMAN-12007: cannot allocate more than number channels

RMAN-12008: could not locate backup piece string

RMAN-12009: command aborted because some backup pieces could not be located

RMAN-12010: automatic channel allocation initialization failed

RMAN-12011: multiple records for default device type found in catalog

RMAN-12012: multiple records for string parallelism found in catalog

RMAN-12013: multiple records for string channel number found in catalog

RMAN-12014: multiple records for default channel configuration for string found in catalog

RMAN-12015: configuration for string channel number is ignored

RMAN-12016: using channel string

RMAN-12017: could not locate pieces of backupset key string

RMAN-12018: channel string disabled, job failed on it will be run on another channel

RMAN-12019: continuing other job steps, job failed will not be re-run

RMAN-12020: error on step filtered for normal output string

RMAN-20000: abnormal termination of job step

RMAN-20001: target database not found in recovery catalog

RMAN-20002: target database already registered in recovery catalog

RMAN-20003: target database incarnation not found in recovery catalog

RMAN-20004: target database name does not match name in recovery catalog

RMAN-20005: target database name is ambiguous

RMAN-20006: target database name is missing

RMAN-20009: database incarnation already registered

RMAN-20010: database incarnation not found

RMAN-20011: target database incarnation is not current in recovery catalog

RMAN-20029: cannot make a snapshot control file

RMAN-20030: resync in progress

RMAN-20031: resync not started

RMAN-20032: checkpoint change# too low

RMAN-20033: control file sequence# too low

RMAN-20034: resync not needed

RMAN-20039: format requires character when duplexing

RMAN-20201: datafile not found in the recovery catalog

RMAN-20202: tablespace not found in the recovery catalog

RMAN-20203: translation in progress

RMAN-20204: translation not started

RMAN-20205: incomplete UNTIL clause

RMAN-20206: log sequence not found in the repository

RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time

RMAN-20208: UNTIL CHANGE is before RESETLOGS change

RMAN-20209: duplicate datafile name

RMAN-20211: FROM TIME is before RESETLOGS time

RMAN-20212: UNTIL CHANGE is an orphan incarnation

RMAN-20215: backup set not found

RMAN-20217: datafile not part of the database

RMAN-20218: datafile not found in recovery catalog

RMAN-20220: control file copy not found in the recovery catalog

RMAN-20221: ambiguous control file copy name

RMAN-20222: datafilename not found in recovery catalog or is ambiguous

RMAN-20230: datafile copy not found in the recovery catalog

RMAN-20231: ambiguous datafile copy name

RMAN-20240: archived log not found in the recovery catalog

RMAN-20241: ambiguous archived log name

RMAN-20250: offline range not found in the recovery catalog

RMAN-20260: backup piece not found in the recovery catalog

RMAN-20261: ambiguous backup piece handle

RMAN-20272: no parent backup found for the incremental backup

RMAN-20280: too many device types

RMAN-20298: DBMS_RCVCAT package not compatible with the recovery catalog

RMAN-20299: DBMS_RCVMAN package not compatible with the recovery catalog

RMAN-20310: proxy copy not found in the recovery catalog

RMAN-20311: ambiguous proxy copy handle

RMAN-20401: script already exists

RMAN-20501: redo logs from parent database incarnation cannot be applied

RMAN-20502: DELETE EXPIRED cannot delete objects that exist - run CROSSCHECK

RMAN-20503: DELETE cannot delete expired objects - run CROSSCHECK or DELETE EXPIRED

RMAN-20504: corruption list not found in recovery catalog

RMAN-20505: create datafile during recovery

RMAN-20506: no backup of archivelog found

RMAN-20507: some targets are remote - aborting restore

[ Previous Section | Next Section ]

Gateway for DB2/400 Installation and User's Guide for IBM iSeries OS/400

Performance

[ Previous Section | Next Section ]

HTML DB User's Guide

About Tuning Performance

[ Previous Section | Next Section ]

New Features Guide

Enhanced Automatic Database Diagnostic Monitor (ADDM) Performance Analysis

[ Previous Section | Next Section ]

OLAP Java API Reference (Javadoc)

Class CursorManagerSpecificationExpiredException

CursorManagerSpecificationExpiredException

CursorManagerSpecificationExpiredException

[ Previous Section | Next Section ]

Oracle Objects for OLE Developer's Guide

Tips and Techniques for Performance Tuning

[ Previous Section | Next Section ]

Platform Guide for Microsoft Windows (32-Bit)

Oracle Counters for Windows Performance Monitor Troubleshooting Information

[ Previous Section | Next Section ]

Platform Guide for Microsoft Windows Itanium (64-Bit)

Oracle Counters for Windows Performance Monitor Troubleshooting Information

[ Previous Section | Next Section ]

Platform Guide for Microsoft Windows x64 (64-Bit)

Oracle Counters for Windows Performance Monitor Troubleshooting Information

[ Previous Section | Next Section ]

Services for Microsoft Transaction Server Developer's Guide

Tracking Oracle Services for Microsoft Transaction Server Performance

[ Previous Section | Next Section ]

SQLJ Developer's Guide and Reference

Performance and Debugging

Performance Enhancement Features

SQLJ Support for Oracle Performance Monitoring

[ Previous Section | Next Section ]

System Administration Guide for IBM z/OS on System z

Performance

[ Previous Section | Next Section ]

Transparent Gateway for DB2 Installation and User's Guide for IBM z/OS (OS/390)

Performance

[ Previous Section | Next Section ]

Ultra Search Java API Reference (Javadoc)

Class UserManagerException

UserManagerException

UserManagerException

[ Previous Section | Next Section ]

Upgrade Guide

Performance Testing


[Back to top]

Index Entries about 'Rman'

The index entries show related terms, and identify the most important places where your subject is mentioned. Content-type: text/html; charset=ISO-8859-1 Oracle Database Master Index 10g Release 2 (10.2)
Home
Home
Customize
Customize
Help
Help
Contact us
Contact Us

Oracle Database Master Index
10g Release 2 (10.2)

Shortcuts to Letters

Instructions

From the links above, select the first letter of the word you want. Find the word in the resulting list and try one or more links to find the right topic.

Notes:



[Back to top]

Bibliography

The links on this page lead to many different books. This section lists PDF files that you can download and print, if you want to do further reading. This section also identifies the relevant chapters that you can print out, rather than printing the entire book.

PDF FileMajor Topics to Print
2 Day + Performance Tuning Guide
  • Getting Started
  • Introduction
  • Tools for Tuning the Database
  • Oracle Database Performance Method
  • Gathering Database Statistics Using the Automatic Workload Repository
  • Time Model Statistics
  • Active Session History Statistics
  • Using the Oracle Performance Method
  • Proactive Database Tuning
  • Automatic Database Performance Monitoring
  • Configuring the Automatic Database Diagnostics Monitor
  • Managing Snapshots
  • Reviewing the Automatic Database Diagnostics Monitor Analysis
  • Implementing ADDM Recommendations
  • Viewing Snapshot Statistics
  • Monitoring Real-Time Database Performance
  • Monitoring User Activity
  • Monitoring Top SQL
  • Monitoring Top Sessions
  • Monitoring Top Services
  • Monitoring Top Modules
  • Monitoring Top Actions
  • Monitoring Instance Activity
  • Monitoring Host Activity
  • Monitoring Disk I/O Utilization
  • Monitoring Performance Alerts
  • Responding to Alerts
  • Reactive Database Tuning
  • Manual Database Performance Monitoring
  • Manually Running ADDM to Analyze Current Database Performance
  • Manually Running ADDM to Analyze Historical Database Performance
  • Accessing Previous ADDM Results
  • Resolving Transient Performance Problems
  • Running Active Session History Reports
  • Using Active Session History Reports
  • Top Events
  • Load Profiles
  • Top SQL
  • Top Sessions
  • Top Objects/Files/Latches
  • Activity Over Time
  • Resolving Performance Degradation Over Time
  • Running the Automatic Workload Repository Compare Periods Reports
  • Using the Automatic Workload Repository Compare Periods Reports
  • Report Summary
  • Wait Events
  • Time Model Statistics
  • SQL Statistics
  • Instance Activity Statistics
  • I/O Statistics
  • Advisory Statistics
  • Wait Statistics
  • Segment Statistics
  • SGA Statistics
  • SQL Tuning
  • Identifying High-Load SQL Statements
  • Identifying High-Load SQL Statements Using Top SQL
  • Viewing SQL Statements by Wait Class
  • Viewing Details of SQL Statements
  • Tuning SQL Statements
  • Managing SQL Tuning Sets
  • Creating a SQL Tuning Set
  • Managing SQL Profiles
  • Optimizing Data Access Paths
  • Running the SQL Access Advisor
  • Running the SQL Access Advisor: Workload Source
  • Running the SQL Access Advisor: Filter Options
  • Running the SQL Access Advisor: Schedule
  • Reviewing the SQL Access Advisor Recommendations
2 Day + Real Application Clusters Guide
  • Backing Up Voting Disks
  • Monitoring Oracle RAC Database Performance
2 Day DBA
  • Performing Restore and Recovery Operations
  • Proactive Database Monitoring
  • Monitoring General Database State and Workload
  • Diagnosing Performance Problems
  • Viewing Performance Analysis
  • Using Advisors to Optimize Database Performance
  • Using the Memory Advisor
Access Manager for AS/400 Installation and User's Guide for IBM iSeries OS/400
  • Error categories
Administrator's Guide
  • Understanding the CREATE DATABASE Statement
  • Specifying FORCE LOGGING Mode
  • Recovering a Control File Using a Current Copy
Administrator's Reference for HP OpenVMS
  • Relinking Executables
  • RDBMS Java File Demonstrations
Administrator's Reference for UNIX-Based Operating Systems
  • AIX Tools
  • Supported Functionality
  • Unicode Support
Advanced Replication Management API Reference
  • Summary of Replication Catalog Views
  • Replication Dynamic Performance Views
Application Developer's Guide - Fundamentals
  • Grouping Operations into Transactions
  • Advantages of Native Dynamic SQL
Application Developer's Guide - Large Objects
  • Performance Guidelines
  • LOB Performance Guidelines
Application Developer's Guide - Object-Relational Features
  • Partitioning Tables That Contain Oracle Objects
  • Design Considerations for Oracle Objects
  • Design Considerations for REFs
  • Design Considerations for Collections
  • Index
Backup and Recovery Advanced User's Guide
  • About the RMAN Environment
  • RMAN Command Line Client
  • Issuing RMAN Commands
  • Backup Solutions Program
  • RMAN Backups Concepts
  • About Image Copies
  • RMAN Backup Options: Naming, Sizing, and Speed
  • Generating Filenames for RMAN Image Copies
  • Control File and Server Parameter File Autobackups
  • Managing Backup Windows and Performance: BACKUP... DURATION
  • How RMAN Responds to Backup Errors
  • Tests and Integrity Checks for Backups
  • Backup Validation with RMAN
  • RMAN Recovery Concepts
  • Restoring Files with RMAN
  • RMAN Media Recovery: Basic Steps
  • Mechanics of Recovery: Incremental Backups and Redo Logs
  • Block Media Recovery When Redo Is Missing
  • Physical Standby Database Creation with RMAN
  • Connecting to Databases with RMAN
  • Connecting to a Target Database and a Recovery Catalog
  • Connecting to an Auxiliary Database
  • Using the RMAN Pipe Interface
  • Configuring the RMAN Environment: Advanced Topics
  • Testing Whether the Media Manager Library Is Integrated Correctly
  • Setting Up RMAN for Use with a Shared Server
  • Making Backups with RMAN: Advanced Topics
  • RMAN Encrypted Backups
  • Understanding RMAN TSPITR
  • RMAN TSPITR Concepts
  • Fully Automated RMAN TSPITR
  • Performing Customized RMAN TSPITR with an RMAN-Managed Auxiliary Instance
  • Performing RMAN TSPITR Using Your Own Auxiliary Instance
  • Troubleshooting RMAN TSPITR
  • RMAN Reporting
  • Deleting RMAN Backups
  • Monitoring RMAN Through V$ Views
  • Correlating Server Sessions with RMAN Channels
  • Working with RMAN Stored Scripts in the Recovery Catalog
  • Step 4: Tune RMAN Tape Streaming Performance Bottlenecks
  • Checkpointing and Cache Recovery
  • Configuring the Duration of Cache Recovery: FAST_START_MTTR_TARGET
  • Interpreting RMAN Message Output
  • Identifying Error Codes
  • Interpreting RMAN Error Stacks
  • Terminating an RMAN Command
  • Terminating an RMAN Session That Is Hung in the Media Manager
  • RMAN Troubleshooting Scenarios
  • After Installation of Media Manager, RMAN Channel Allocation Fails: Scenario
  • RMAN Fails to Start RPC Call: Scenario
  • RMAN Fails to Delete All Archived Logs: Scenario
  • Backup Fails Because RMAN Cannot Locate an Archived Log: Scenario
  • RMAN Does Not Recognize Character Set Name: Scenario
  • RMAN Denies Logon to Target Database: Scenario
  • Duplication Fails with Multiple RMAN-06023 Errors: Scenario
  • Using RMAN for Database Transport, Duplication and Migration
  • Creating and Updating Duplicate Databases with RMAN
  • Creating a Duplicate Database with RMAN: Overview
  • Renaming Database Files in RMAN Duplicate Database
  • Creating a Duplicate Database on a Local or Remote Host
  • Duplicating a Database on a Remote Host with a Different Directory Structure
  • Using RMAN DUPLICATE with OMF and ASM
  • Using RMAN DUPLICATE DATABASE: Examples
  • Duplicating with a Client-Side Parameter File: Example
  • Refreshing a Standby Database With INCREMENTAL FROM SCN Backups: Example
  • Creating Transportable Tablespace Sets from Backup with RMAN
  • Transportable Tablespace Sets from Backup: Concepts
  • How RMAN Creates Transportable Tablespace Sets from Backup
  • Creating a Transportable Tablespace Set with RMAN: Procedure
  • Troubleshooting RMAN TRANSPORT TABLESPACE
  • Performing Cross-Platform Database Transport
  • Executing the RECOVER ... TEST Statement
Backup and Recovery Basics
  • Choosing a Backup Retention Policy
  • Validating Your Data Recovery Strategy
  • Overview of Interacting With the RMAN Client
  • Checking Syntax of RMAN Commands and Command Files: CHECKSYNTAX
  • Connecting the RMAN Client to Databases
  • Setting Up a Database for RMAN Backup
  • Persistent Configuration Settings: Controlling RMAN Behavior
  • Creating a Database with Only Archived Logs in the Flash Recovery Area: Scenario
  • Backing Up Databases Using RMAN
  • Overview of RMAN Backups
  • Specifying Options Affecting Output of the RMAN BACKUP Command
  • Backing Up Database Files and Archived Logs with RMAN
  • RMAN Incremental Backups
  • Listing RMAN Backups, Archived Logs, and Database Incarnations
  • Reporting on Backups and Database Schema
  • Reporting on Files Needing a Backup Under a Retention Policy
  • Setup and Maintenance for Oracle Flashback Database
  • Restoring the Server Parameter File (SPFILE) from Backup
  • Using CROSSCHECK to Update the RMAN Repository
  • Deleting Backups
  • Using Multiple RMAN Channels for Maintenance Operations
  • Uncataloging RMAN Records
  • Flash Recovery Area Behavior When Instance Crashes During File Creation
  • RMAN-Based Disk and Tape Backup Strategies: Scenarios
  • Backing Up to the Flash Recovery Area and to Tape: Basic Scenarios
Backup and Recovery Reference
  • About RMAN Commands
  • Conventions Used in this Reference
  • RMAN Command Format, Syntax Diagrams and Notation
  • RMAN Command Entries
  • RMAN Code Examples
  • RMAN Commands
  • RC_UNUSABLE_BACKUPFILE_DETAILS
  • Deprecated RMAN Commands
  • RMAN Compatibility
Concepts
  • Oracle Database Features
  • Key Compression
  • Introduction to Backup
  • RMAN and User-Managed Backups
  • Introduction to Recovery
  • Overview of RMAN and User-Managed Restore and Recovery
  • Overview of Integrity Constraints
  • Advantages of Integrity Constraints
  • Overview of Java
Data Cartridge Developer's Guide
Data Guard Broker
  • Fast-Start Failover
  • Scenario 8: Monitoring a Data Guard Configuration
  • Monitoring Configuration Performance
  • General Problems and Solutions
Data Guard Concepts and Administration
  • Verification
  • Adjust How Transactions are Applied On the Logical Standby Database
  • Using RMAN to Back Up and Restore Files
  • Preparing to Use RMAN to Create a Standby Database
Data Mining Application Developer's Guide
  • Using ODM BLAST
Data Provider for .NET Developer's Guide
  • Obtaining LOB Data
  • Database Change Notification Support
  • Index
Data Warehousing Guide
  • Partition-Wise Joins
  • Initializing and Tuning Parameters for Parallel Execution
  • Monitoring and Diagnosing Parallel Execution Performance
Database Client Installation Guide for Microsoft Windows
  • Recommended Postinstallation Tasks
Database Client Installation Guide for Microsoft Windows (x64)
  • Recommended Postinstallation Tasks
Database Client Installation Guide for Microsoft Windows Itanium (64-Bit)
  • Recommended Postinstallation Tasks
Database Gateway for DB2/400 Installation and User's Guide for IBM iSeries OS/400
  • Error Categories
Database Installation Guide for AIX 5L Based Systems (64-Bit)
Database Installation Guide for Apple Mac OS X (Intel)
Database Installation Guide for HP OpenVMS
  • Server Log File
Database Installation Guide for hp Tru64 UNIX
Database Installation Guide for HP-UX Itanium
Database Installation Guide for HP-UX PA-RISC (64-Bit)
Database Installation Guide for Linux Itanium
Database Installation Guide for Linux on POWER
Database Installation Guide for Linux x86
Database Installation Guide for Linux x86-64
Database Installation Guide for Microsoft Windows (32-Bit)
  • Configuring Oracle Components
Database Installation Guide for Microsoft Windows Itanium (64-Bit)
  • Configuring Oracle Components
Database Installation Guide for Microsoft Windows x64
  • Configuring Oracle Components
Database Installation Guide for Solaris Operating System (SPARC 64-Bit)
Database Installation Guide for Solaris Operating System (x86)
Database Installation Guide for Solaris Operating System (x86-64)
Database Vault Administrator's Guide
Enterprise Manager Advanced Configuration
  • Configuring End-User Performance Monitoring
  • Configuring End-User Performance Monitoring Using Oracle Application Server Web Cache
  • Managing Forms Applications
  • Monitoring the End-User Performance of Forms Applications
  • Configuring OC4J for Request Performance Diagnostics
  • Troubleshooting
  • Sizing and Maximizing the Performance of Oracle Enterprise Manager
Enterprise Manager Concepts
  • Monitoring Databases
  • Assessing Database Performance
  • Administering Databases
  • Modeling Services
  • Monitoring Services
  • Monitoring Web Application Services
  • Monitoring Forms Applications
  • Diagnosing Web Application Problems
  • Monitoring Middleware Targets
  • Monitoring Performance
  • Administering Middleware Targets
  • Managing Identity Management Targets
  • Monitoring Hosts
Enterprise Manager Framework, Host, and Services Metric Reference Manual
Enterprise Manager Oracle Database and Database-Related Metric Reference Manual
Enterprise Manager Policy Reference Manual
  • Storage Policies
  • Storage Policies
  • Configuration Policies
Enterprise Manager SNMP Support Reference Guide
Error Messages
  • OCI-31116: Tablespace not specified correctly
  • RMAN-00550 to RMAN-20507
Globalization Support Guide
  • NLS_LANGUAGE
  • NLS_TERRITORY
  • Time Formats
  • Choosing a Time Zone File
  • Linguistic Sort Examples
  • Example: Setting Up a French Linguistic Index
  • The NLSSORT Function
  • Storage and Performance Considerations in the Database Character Set Scanner
Heterogeneous Connectivity Administrator's Guide
  • Using Heterogeneous Services Agents
  • Performance Recommendations
High Availability Best Practices
  • Configuring Oracle Database 10g with Data Guard
  • Use Database Target Views to Monitor Health, Availability, and Performance
  • recovery time objective (RTO)
High Availability Overview
  • High Availability Architecture Requirements
HTML DB User's Guide
  • Debugging an Application
HTTP Server mod_plsql User's Guide
  • Accessing the PlsqlExclusionList Directive
  • Optimizing PL/SQL Performance
interMedia User's Guide
  • Tuning Tips for the DBA
JDBC Developer's Guide and Reference
  • JDBC 2.0 Support: JDK 1.2.x and Later Versions
  • Data Sources
  • Performance Enhancements
  • Enabling Run-Time Connection Load Balancing
  • Performance Extensions
Label Security Administrator's Guide
  • Performance Tips for Oracle Label Security
Net Services Administrator's Guide
  • Deploying a Network Inside an Organization
  • Security
  • Configuring Oracle Net Services for an Oracle Rdb Database
  • Optimizing Performance
New Features Guide
  • SQL Language Improvements
  • High Availability Improvements
  • Clustering
  • Database Management
  • Information Integration
  • Oracle Streams Performance and Usability Improvements
  • Location Services
  • Performance and Scalability
  • Improved Large Object (LOB) Performance
  • Other Performance Improvements
  • Improved Intelligent Infrastructure
  • Windows
  • Performance Improvements
OLAP Application Developer's Guide
  • Storage Management
  • Information Requirements
OLAP Developer's Guide to the OLAP API
  • Overview of the OLAP API Cursor Objects
  • CursorManager Classes
  • Specifying the Behavior of a Cursor
OLAP DML Reference
  • TRIGGERSTOREOK
OLAP Java API Reference (Javadoc)
  • How This API Document Is Organized
  • Class ExpressDataProvider
  • How This API Document Is Organized
  • Interface CursorManager
  • Interface CursorManagerUpdateListener
  • Class CursorManagerUpdateEvent
  • How This API Document Is Organized
  • Class DataProvider
  • Class CursorManagerSpecificationExpiredException
  • Example Oracle OLAP Java API and Analytic Workspace Java API Programs
OLAP Reference
  • ALL_OLAP2_AW_PHYS_OBJ_PROP
  • OLAP Dynamic Performance Views
Oracle C++ Call Interface Programmer's Guide
  • Determining Client and Server Versions
  • Executing SQL Queries
  • APIs for XA Support
  • Optimizing Performance of OCCI Applications
Oracle Call Interface Programmer's Guide
  • Scrollable Cursors in OCI
  • LOB and BFILE Functions in OCI
Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide
  • Managing Oracle Real Application Clusters Environments
  • RMAN Restore Scenarios for Oracle Real Application Clusters
  • Instance Recovery in Oracle Real Application Clusters
  • Distributed Transactions and Oracle Real Application Clusters
  • Monitoring Performance
  • Monitoring Oracle Real Application Clusters Statistics and Events
  • Monitoring Performance by Analyzing GCS and GES Statistics
  • Monitoring Performance with Oracle Enterprise Manager
  • Using the Cluster Database Performance Page
Oracle Objects for OLE Developer's Guide
  • Using Large Objects (LOBs)
  • Tuning and Troubleshooting
  • Index
Performance Tuning Guide
  • Performance Tuning
  • Performance Tuning Overview
  • Introduction to Performance Tuning
  • Instance Tuning
  • SQL Tuning
  • Introduction to Performance Tuning Features and Tools
  • Additional Oracle Tools
  • Performance Planning
  • Designing and Developing for Performance
  • Understanding Scalability
  • System Scalability
  • System Architecture
  • Hardware and Software Components
  • Application Design Principles
  • Table and Index Design
  • Workload Testing, Modeling, and Implementation
  • Estimating Workloads
  • Deploying New Applications
  • Performance Checklist
  • Performance Improvement Methods
  • The Oracle Performance Improvement Method
  • Emergency Performance Methods
  • Optimizing Instance Performance
  • Configuring a Database for Performance
  • Performance Considerations for Initial Instance Configuration
  • Creating Subsequent Tablespaces
  • Creating and Maintaining Tables for Good Performance
  • Table Compression
  • Indexing Data
  • Performance Considerations for Shared Servers
  • Identifying Contention Using the Dispatcher-Specific Views
  • Identifying Contention for Shared Servers
  • Automatic Performance Statistics
  • Overview of Data Gathering
  • Database Statistics
  • Operating System Statistics
  • Overview of the Automatic Workload Repository
  • Managing the Automatic Workload Repository
  • Managing Snapshots
  • Managing Baselines
  • Transporting Automatic Workload Repository Data
  • Generating Automatic Workload Repository Reports
  • Generating Active Session History Reports
  • Automatic Performance Diagnostics
  • Automatic Database Diagnostic Monitor
  • An ADDM Example
  • Diagnosing Database Performance Issues with ADDM
  • Views with ADDM Information
  • Memory Configuration and Use
  • Understanding Memory Allocation Issues
  • Dynamically Changing Cache Sizes
  • Operating System Memory Use
  • Configuring and Using the Buffer Cache
  • Sizing the Buffer Cache
  • Interpreting and Using the Buffer Cache Advisory Statistics
  • Considering Multiple Buffer Pools
  • Configuring and Using the Shared Pool and Large Pool
  • Shared Pool Concepts
  • Using the Shared Pool Effectively
  • Sizing the Shared Pool
  • Interpreting Shared Pool Statistics
  • Using the Large Pool
  • Configuring the Reserved Pool
  • CURSOR_SHARING for Existing Applications
  • Configuring and Using the Redo Log Buffer
  • PGA Memory Management
  • Configuring Automatic PGA Memory
  • Configuring OLAP_PAGE_POOL_SIZE
  • I/O Configuration and Design
  • Basic I/O Configuration
  • Lay Out the Files Using Operating System or Hardware Striping
  • When to Separate Files
  • Three Sample Configurations
  • Oracle-Managed Files
  • Choosing Data Block Size
  • Understanding Operating System Resources
  • Understanding Operating System Performance Issues
  • Using Operating System Caches
  • Memory Usage
  • Solving Operating System Problems
  • Understanding CPU
  • Finding System CPU Utilization
  • Checking Memory Management
  • Checking Process Management
  • Instance Tuning Using Performance Views
  • Instance Tuning Steps
  • Examine the Host System
  • Examine the Oracle Statistics
  • Interpreting Oracle Statistics
  • Examine Load
  • Additional Statistics
  • Wait Events Statistics
  • SQL*Net Events
  • buffer busy waits
  • db file scattered read
  • db file sequential read
  • direct path read and direct path read temp
  • direct path write and direct path write temp
  • enqueue (enq:) waits
  • free buffer waits
  • latch events
  • log file switch
  • Optimizing SQL Statements
  • SQL Tuning Overview
  • Goals for Tuning
  • Identifying High-Load SQL
  • Identifying Resource-Intensive SQL
  • Gathering Data on the SQL Identified
  • Developing Efficient SQL Statements
  • Restructuring the SQL Statements
  • Controlling the Access Path and Join Order with Hints
  • Visiting Data as Few Times as Possible
  • Automatic SQL Tuning
  • Automatic SQL Tuning Overview
  • Query Optimizer Modes
  • Types of Tuning Analysis
  • SQL Tuning Advisor
  • Using SQL Tuning Advisor APIs
  • SQL Tuning Sets
  • SQL Profiles
  • SQL Tuning Information Views
  • The Query Optimizer
  • Choosing an Optimizer Goal
  • Enabling and Controlling Query Optimizer Features
  • Understanding the Query Optimizer
  • Components of the Query Optimizer
  • Reading and Understanding Execution Plans
  • Understanding Access Paths for the Query Optimizer
  • Full Table Scans
  • Rowid Scans
  • Index Scans
  • Sample Table Scans
  • Understanding Joins
  • Nested Loop Joins
  • Hash Joins
  • Sort Merge Joins
  • Cartesian Joins
  • Outer Joins
  • Managing Optimizer Statistics
  • Automatic Statistics Gathering
  • Considerations When Gathering Statistics
  • Manual Statistics Gathering
  • Gathering Statistics with DBMS_STATS Procedures
  • System Statistics
  • Workload Statistics
  • Noworkload Statistics
  • Managing Statistics
  • Estimating Statistics with Dynamic Sampling
  • Viewing Statistics
  • Viewing Histograms
  • Using Indexes and Clusters
  • Understanding Index Performance
  • Choosing Composite Indexes
  • Using Hash Clusters for Performance
  • Using Optimizer Hints
  • Understanding Optimizer Hints
  • Hints by Category
  • Specifying Hints
  • Specifying a Full Set of Hints
  • Specifying a Query Block in a Hint
  • Specifying Global Table Hints
  • Using Hints with Views
  • Hints and Nonmergeable Views
  • SQL Access Advisor
  • Overview of the SQL Access Advisor in the DBMS_ADVISOR Package
  • Overview of Using the SQL Access Advisor
  • Using the SQL Access Advisor
  • Steps for Using the SQL Access Advisor
  • Setting Up Tasks and Templates
  • Managing Workloads
  • Working with Recommendations
  • Managing Tasks
  • Examples of Using the SQL Access Advisor
  • Tuning Materialized Views for Fast Refresh and Query Rewrite
  • DBMS_ADVISOR.TUNE_MVIEW Procedure
  • Using Plan Stability
  • Using Plan Stability to Preserve Execution Plans
  • Using Hints with Plan Stability
  • Creating Outlines
  • Using Plan Stability with Query Optimizer Upgrades
  • Moving to a New Oracle Release under the Query Optimizer
  • Using EXPLAIN PLAN
  • Understanding EXPLAIN PLAN
  • How Execution Plans Can Change
  • Minimizing Throw-Away
  • Looking Beyond Execution Plans
  • The PLAN_TABLE Output Table
  • Running EXPLAIN PLAN
  • Identifying Statements for EXPLAIN PLAN
  • Specifying Different Tables for EXPLAIN PLAN
  • Displaying PLAN_TABLE Output
  • Reading EXPLAIN PLAN Output
  • Viewing Parallel Execution with EXPLAIN PLAN
  • Viewing Parallel Queries with EXPLAIN PLAN
  • Viewing Bitmap Indexes with EXPLAIN PLAN
  • Viewing Partitioned Objects with EXPLAIN PLAN
  • Examples of Displaying Range and Hash Partitioning with EXPLAIN PLAN
  • Examples of Partial Partition-wise Joins
  • Examples of Full Partition-wise Joins
  • Examples of INLIST ITERATOR and EXPLAIN PLAN
  • PLAN_TABLE Columns
  • Using Application Tracing Tools
  • End to End Application Tracing
  • Enabling and Disabling Statistic Gathering for End to End Tracing
  • Enabling and Disabling for End to End Tracing
  • Using the trcsess Utility
  • Understanding SQL Trace and TKPROF
  • Using the SQL Trace Facility and TKPROF
  • Step 3: Formatting Trace Files with TKPROF
  • Step 4: Interpreting TKPROF Output
  • Step 5: Storing SQL Trace Facility Statistics
  • Avoiding Pitfalls in TKPROF Interpretation
  • Sample TKPROF Output
  • Real Application Testing
  • Database Replay
  • Overview of Database Replay
  • Capturing a Database Workload
  • Workload Capture Options
  • Monitoring Workload Capture Using Enterprise Manager
  • Capturing a Database Workload Using APIs
  • Analyzing Workload Capture
  • Using a Workload Capture Report
  • SQL Performance Analyzer
  • Overview of SQL Performance Analyzer
  • Capturing the SQL Workload
PL/SQL User's Guide and Reference
  • What's New in PL/SQL?
  • Advantages of PL/SQL
  • Better Performance
  • Guidelines for Using Dynamic SQL with PL/SQL
  • Tuning PL/SQL Applications for Performance
  • Avoiding CPU Overhead in PL/SQL Code
Platform Guide for Microsoft Windows (32-Bit)
  • Using Windows Tools
  • Using Oracle Counters for Windows Performance Monitor
Platform Guide for Microsoft Windows Itanium (64-Bit)
  • Using Windows Tools
  • Using Oracle Counters for Windows Performance Monitor
Platform Guide for Microsoft Windows x64 (64-Bit)
  • Using Windows Tools
  • Using Oracle Counters for Windows Performance Monitor
Pro*C/C++ Programmer's Guide
  • Demo Program:1
  • Demo Program:2
  • Using Embedded PL/SQL
Pro*COBOL Programmer's Guide
  • Using PL/SQL and Java
Programmer's Guide to the Oracle Precompilers
  • Using Embedded PL/SQL
Real Application Testing User's Guide
  • Overview of SQL Performance Analyzer
Reference
  • Dynamic Performance Views
  • Dynamic Performance (V$) Views
  • V$MYSTAT
  • Dynamic Performance (V$) Views: V$NLS_PARAMETERS to V$XML_AUDIT_TRAIL
Secure Backup Administrator's Guide
  • Overview of Recovery Manager and Oracle Secure Backup
  • How RMAN Accesses Oracle Secure Backup
  • Configuring RMAN and Oracle Secure Backup
  • Creating a Preauthorized Oracle Secure Backup Account
  • Managing RMAN Metadata in Oracle Secure Backup
  • Using RMAN and Oracle Secure Backup in a Real Application Clusters Environment
  • Cataloging the Contents of a Backup Image
Secure Backup Reference
  • obtar -t
  • Operations Policies
  • Defining the Scope of a Backup
  • RMAN Media Management Parameters
Secure Enterprise Search Administrator's Guide
Security Guide
  • How to Add a Policy to a Table, View, or Synonym
Services for Microsoft Transaction Server Developer's Guide
  • Using Microsoft Oracle ODBC Driver
  • Tuning Microsoft Transaction Server Performance
Spatial User's Guide and Reference
SQL*Plus User's Guide and Reference
  • Statistics
SQLJ Developer's Guide and Reference
  • Manipulation Outside of SQLJ for Globalization Support
  • Performance and Debugging
Streams Advanced Queuing User's Guide and Reference
  • Oracle Streams AQ Performance and Scalability
Streams Concepts and Administration
  • Monitoring Buffered Queues
  • Task 3: Instantiating the Database
  • Task 3: Instantiating the Database
Streams Replication Administrator's Guide
  • Instantiating Objects in a Streams Replication Environment
  • Instantiating Objects in a Tablespace Using Transportable Tablespace or RMAN
  • Instantiating an Entire Database Using RMAN
System Administration Guide for IBM z/OS on System z
  • Recovery Manager on z/OS
  • Error Categories
Text Application Developer's Guide
  • Tuning Oracle Text
  • Frequently Asked Questions a About Query Performance
  • Frequently Asked Questions About Indexing Performance
Text Reference
  • Lexer
  • Lexical Compiler (ctxlc)
  • Overview of Alternative Spelling Features
  • Alternative Spelling Conventions
  • Oracle Text Supplied Stoplists
Transparent Gateway for DB2 Installation and User's Guide for IBM z/OS (OS/390)
  • Error Categories
Ultra Search Administrator's Guide
  • Tuning and Performance in Oracle Ultra Search
  • Index
Ultra Search Java API Reference (Javadoc)
  • How This API Document Is Organized
  • Class Instance
  • Class JaznUserManager
  • Class UserManager
  • Class UserManagerException
Upgrade Guide
  • Develop a Testing Plan
  • Compatibility and Interoperability Issues Introduced in Oracle Database 10g Release 10.1
  • Creating a Statistics Table
Utilities
  • What Happens During Execution of a Data Pump Job?
  • Data Pump Performance
  • Conventional and Direct Path Loads
  • Building Indexes
  • Direct Loads, Integrity Constraints, and Triggers
  • Invoking a Direct Path Export
XML DB Developer's Guide
  • Understanding and Optimizing XPath Rewrite
  • CTXXPATH Indexes on XMLType Columns
XML Java API Reference (Javadoc)
  • How This API Document Is Organized
  • Class ProviderManagerClient
  • How This API Document Is Organized
  • How This API Document Is Organized
  • Class ProviderManagerImpl
  • Class ServerUtils