How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Contents → Conventions 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 22.214.171.124 Performance Principles
Tuning Rebalance Operations → If 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
Tuning Distributed Queries → The 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
Candidates for Tuning → The 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
Performance Tuning → Part I Performance Tuning Part I provides an introduction and overview of performance tuning. The … chapter in this part is: Chapter 1, \"Performance Tuning Overview\"
17.3 Tuning Reactively with SQL Tuning Advisor → You 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
17.3.2 Tuning Options → SQL 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
16.2 Goals for Tuning → The objective of tuning a system is either to reduce the response time for end users of the system
Tuning RMAN Backup Performance → $BACKUP_ASYNC_IO views Tuning RMAN Backup Performance Many factors can affect backup performance
10.1 Instance Tuning Steps → These 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
1.1.2 Instance Tuning → Part 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
16.4.2 SQL Tuning Advisor → SQL 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
16.4.3 SQL Tuning Sets → When 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\".
17.6 SQL Tuning Views → This 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
1 Performance Tuning Overview → This chapter provides an introduction to performance tuning and contains the following sections … : Introduction to Performance Tuning Introduction to Performance Tuning Features and Tools
16 SQL Tuning Overview → This 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
1.1.3 SQL Tuning → Part IV, \"Optimizing SQL Statements\" of this guide discusses the process of tuning and optimizing
17 Automatic SQL Tuning → This 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
22 Tuning RMAN Performance → This 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
Tuning and Troubleshooting → Part 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\"