You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for tuning


1 to 20 of 2307 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Performance Tuning Guide, 11g Release 2 (11.2)

Database Performance Tuning Guide - Contents

ContentsConventions What's New in Oracle Database Performance Tuning Guide? Oracle Database 11 g Release 2 … Database Performance Part I Performance Tuning 1 Performance Tuning Overview 1.1 Introduction to … Performance Tuning 1.1.1 Performance Planning 1.1.2 Instance Tuning 1.1.2.1 Performance Principles

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle ASM Disk Groups

Tuning Rebalance OperationsIf the POWER clause is not specified in an ALTER DISKGROUP statement, or when rebalance is implicitly run by adding or dropping a disk, then the rebalance power defaults to the value of the ASM_POWER_LIMIT initialization parameter. You can adjust the value of this parameter dynamically. The higher the power limit, the more quickly a rebalance operation can complete. Rebalancing takes longer with lower

Database Administrator's Guide, 11g Release 2 (11.2)

Developing Applications for a Distributed Database System

Tuning Distributed QueriesThe local Oracle Database server breaks the distributed query into a corresponding number of remote queries, which it then sends to the remote nodes for execution. The remote nodes execute the queries and send the results back to the local node. The local node then performs any necessary post-processing and returns the results to the user or application. You have several options for designing your

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Optimization and Tuning

Candidates for TuningThe following kinds of PL/SQL code are very likely to benefit from tuning: Older code that does not … , see \"What's New in PL/SQL?\". Tip: Before tuning older code, benchmark the current system and … \" ), you might see performance improvements before doing any tuning. Older dynamic SQL statements

Database Performance Tuning Guide, 11g Release 2 (11.2)

Performance Tuning

Performance TuningPart I Performance Tuning Part I provides an introduction and overview of performance tuning. The … chapter in this part is: Chapter 1, \"Performance Tuning Overview\"

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic SQL Tuning

17.3 Tuning Reactively with SQL Tuning AdvisorYou can invoke SQL Tuning Advisor manually for on-demand tuning of one or more SQL statements. To … tune multiple statements, you must create a SQL tuning set (STS). A SQL tuning set is a database … object that stores SQL statements along with their execution context. You can create a SQL tuning set

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic SQL Tuning

17.3.2 Tuning OptionsSQL Tuning Advisor provides options to manage the scope and duration of a tuning task. You can set … the scope of a tuning task either of the following: Limited In this case, SQL Tuning Advisor … profile recommendations are not generated. Comprehensive In this case, SQL Tuning Advisor carries

Database Performance Tuning Guide, 11g Release 2 (11.2)

SQL Tuning Overview

16.2 Goals for TuningThe objective of tuning a system is either to reduce the response time for end users of the system

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Tuning RMAN Performance

Tuning RMAN Backup Performance$BACKUP_ASYNC_IO views Tuning RMAN Backup Performance Many factors can affect backup performance

Database Performance Tuning Guide, 11g Release 2 (11.2)

Instance Tuning Using Performance Views

10.1 Instance Tuning StepsThese are the main steps in the Oracle performance method for instance tuning: Define the Problem … chapter discusses instance tuning using the Oracle Database dynamic performance views. However … (ADDM) for statistics gathering, monitoring, and tuning due to the extended feature list. See

Database Performance Tuning Guide, 11g Release 2 (11.2)

Performance Tuning Overview

1.1.2 Instance TuningPart III, \"Optimizing Instance Performance\" discusses the factors involved in the tuning and … optimizing of an Oracle database instance. When considering instance tuning, take care in the initial … parts of the database Tuning the operating system for optimal performance of the database After the … check for performance-related

Database Performance Tuning Guide, 11g Release 2 (11.2)

SQL Tuning Overview

16.4.2 SQL Tuning AdvisorSQL Tuning Advisor optimizes SQL statements that have been identified as high-load SQL statements … tuning recommendations using SQL Tuning Advisor during system maintenance windows as an automated … can also choose to run SQL Tuning Advisor at any time on any given SQL workload to improve performance. See \"Tuning

Database Performance Tuning Guide, 11g Release 2 (11.2)

SQL Tuning Overview

16.4.3 SQL Tuning SetsWhen multiple SQL statements serve as input to ADDM, SQL Tuning Advisor, or SQL Access Advisor, the … database constructs and stores a SQL tuning set (STS). The STS includes the set of SQL statements … along with their associated execution context and basic execution statistics. See \"Managing SQL Tuning Sets\".

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic SQL Tuning

17.6 SQL Tuning ViewsThis section summarizes views that shows information gathered for tuning the SQL statements. You … views. SQL tuning information views, such as DBA_SQLTUNE_STATISTICS, DBA_SQLTUNE_BINDS, and … DBA_SQLTUNE_PLANS views. SQL tuning set views, such as DBA_SQLSET, DBA_SQLSET_BINDS, DBA_SQLSET_STATEMENTS, and … DBA_SQLSET_REFERENCES

Database Performance Tuning Guide, 11g Release 2 (11.2)

Performance Tuning Overview

1 Performance Tuning OverviewThis chapter provides an introduction to performance tuning and contains the following sections … : Introduction to Performance Tuning Introduction to Performance Tuning Features and Tools

Database Performance Tuning Guide, 11g Release 2 (11.2)

SQL Tuning Overview

16 SQL Tuning OverviewThis chapter discusses goals for tuning, how to identify high-resource SQL statements, explains … what should be collected, provides tuning suggestions, and discusses how to create SQL test cases to … troubleshoot problems in SQL. This chapter contains the following sections: Introduction to SQL Tuning … Goals for Tuning

Database Performance Tuning Guide, 11g Release 2 (11.2)

Performance Tuning Overview

1.1.3 SQL TuningPart IV, \"Optimizing SQL Statements\" of this guide discusses the process of tuning and optimizing

Database Performance Tuning Guide, 11g Release 2 (11.2)

Automatic SQL Tuning

17 Automatic SQL TuningThis chapter discusses the automatic SQL tuning features of Oracle Database. Automatic SQL tuning … the following sections: Overview of the Automatic Tuning Optimizer Managing the Automatic SQL … Tuning Advisor Tuning Reactively with SQL Tuning Advisor Managing SQL Tuning

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Tuning RMAN Performance

22 Tuning RMAN PerformanceThis chapter contains the following topics: Purpose of RMAN Performance Tuning Basic Concepts of … RMAN Performance Tuning Using V$ Views to Diagnose RMAN Performance Problems Tuning RMAN Backup Performance

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Tuning and Troubleshooting

Tuning and TroubleshootingPart VI Tuning and Troubleshooting The following chapters describe how to tune and troubleshoot … RMAN operations. This part of the book contains these chapters: Chapter 22, \"Tuning RMAN Performance\" Chapter 23, \"Troubleshooting RMAN Operations\"