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 → Integration with SQL High Performance High Productivity Full Portability Tight Security Access to Predefined … DBMS_WARNING Package 12 Tuning PL/SQL Applications for Performance How PL/SQL Optimizes Your Programs When … to Tune PL/SQL Code Guidelines for Avoiding PL/SQL
Running SQL Performance Analyzer → SQL Performance Analyzer enables you to analyze the effects of environmental changes on execution … and execution context. In addition to the performance analysis, SQL Performance Analyzer can invoke … SQL Advisor and provide tuning recommendations.
Running SQL Performance Analyzer → input source to run SQL Performance Analyzer. Running SQL Performance Analyzer involves creating SQL … Performance Analyzer: Create a SQL Performance Analyzer task, as described in \"Creating
SQL Performance Analyzer Usage → You can use SQL Performance Analyzer to analyze the SQL performance impact of any type of system … version of the optimizer, which has an effect on SQL performance. SQL Performance Analyzer enables you to … Performance
SQL Performance Analyzer Methodology → You can run SQL Performance Analyzer on a test system that closely resembles the production system … , or on the production system itself. Performing a SQL Performance Analyzer analysis is resource … separate test system is available, then running SQL Performance
SQL Performance Analyzer → performance of the SQL statements improves. SQL Performance Analyzer automates the process of assessing … provided. For regressed SQL statements, SQL Performance Analyzer also provides appropriate … the SQL Performance
1 SQL Performance Analyzer → SQL Performance Analyzer enables you to assess the performance impact of any system change … changes for which you can use SQL Performance Analyzer include: Database upgrade Configuration changes to … specifically describes how to use SQL Performance
SQL Performance Analyzer → Part II SQL Performance Analyzer SQL Performance Analyzer enables you to assess the impact of … , \"Introduction to SQL Performance Analyzer\" Chapter 8, \"Creating an Analysis Task\" Chapter 9 … system changes on the response time of
Using SQL Performance Analyzer Views → You can query the following views to monitor SQL Performance Analyzer and view its analysis results … : Note: The information available in these views are also contained in the SQL Performance Analyzer … report. It is recommended that you use the SQL Performance
12 Tuning PL/SQL Applications for Performance → Performance Problems Collecting Data About User-Defined Identifiers Profiling and Tracing PL/SQL … This chapter explains how to write efficient new PL/SQL code and speed up existing PL/SQL code … . Topics: How PL/SQL Optimizes Your Programs When to Tune PL/SQL Code Guidelines for Avoiding
Guidelines for Avoiding PL/SQL Performance Problems → When a PL/SQL-based application performs poorly, it is often due to badly written SQL statements … , poor programming practices, inattention to PL/SQL basics, or misuse of shared memory. Topics … : Avoiding CPU Overhead in PL/SQL Code Avoiding Memory Overhead in PL/SQL Code
Creating a SQL Performance Analyzer Task → This section describes how to create a new SQL Performance Analyzer task on the system running … container for SQL Performance Analyzer execution inputs and results. Before creating the task, ensure that … specify the name for the SQL Performance Analyzer
7 Introduction to SQL Performance Analyzer → You can run SQL Performance Analyzer on a production system or a test system that closely resembles … throughput because SQL Performance Analyzer needs to execute the SQL statements that you are testing … running on the production system will not affect the analysis
Reviewing the SQL Performance Analyzer Report → When a SQL Performance Analyzer task is completed, the resulting data is generated into a report … . This section shows a sample of a SQL Performance Analyzer report. This sample report uses the elapsed … . Description of the illustration spa_task_result.gif To review the SQL
Creating a SQL Performance Analyzer Task → environment is properly configured, you can run SQL Performance Analyzer to analyze the effects of a … system change on SQL performance. To run SQL Performance Analyzer, you must first create a SQL … Performance Analyzer
Contents → Performance Impact SQL Performance Analyzer Usage SQL Performance Analyzer Methodology Capturing and … Workload Running SQL Performance Analyzer Testing an Initialization Parameter Change with SQL Performance
Tuning Regressed SQL → After reviewing the SQL Performance Analyzer report, you should tune any regressed SQL statements … regressed SQL statements, you should test these changes using SQL Performance Analyzer. Run a new remote … pre-upgrade SQL trial) to
Testing Database Upgrade from Oracle Database 9i to Oracle Database 10g → SQL Performance Analyzer accepts a representative set of SQL statements stored in a SQL tuning set … tuning set that can be used as an input source for SQL Performance Analyzer. Once constructed, you can … use SQL Performance
Creating a Mapping Table → To convert the user and object identifier numbers stored in the SQL trace files to their respective … mapping table when converting the trace files into a SQL tuning set. To create a mapping table, run … the following SQL statements on the production database running Oracle Database 9 i: create table
Building the Pre-Upgrade SQL Trial → After the SQL Performance Analyzer task is created on the system running Oracle Database 11 g, you … parameter to the name of the SQL Performance Analyzer task that you want to execute. Set the … execution_type parameter to CONVERT SQLSET to direct SQL Performance