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 execution plan


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


Database Administrator's Guide

Developing Applications for a Distributed Database System

Analyzing the Execution PlanAn important aspect to tuning distributed queries is analyzing the execution plan. The feedback … execution plan for a distributed query optimized by cost-based optimization to a plan for a query … Performance Tuning Guide for detailed information about execution plans, the EXPLAIN PLAN

Database Performance Tuning Guide

SQL Tuning Overview

16.5.2 Reviewing the Execution Planaccess paths are optimal. When examining the optimizer execution plan, look for the following: The

Database Concepts

Glossary

execution planretrieves rows of data physically from the database or prepares them for the user issuing the statement. You can override execution plans by using hints.

Database Performance Tuning Guide

The Query Optimizer

11.4.2 Steps in the Execution PlanEach row in the output table corresponds to a single step in the execution plan. Note that the step … EXPLAIN PLAN\" Each step of the execution plan returns a set of rows. The next step either uses these … which they are displayed in response to the EXPLAIN PLAN statement. Each step

Database Performance Tuning Guide

Using Plan Stability

20.1 Using Plan Stability to Preserve Execution Plansperformance changes in an application. Plan stability preserves execution plans in stored outlines. An … stored hints and tries to generate an execution plan in accordance with those hints. Oracle Database … outlines also stabilizes the generated execution plan if the optimizer changes

SQL*Plus User's Guide and Reference

Tuning SQL*Plus

Execution PlanThe Execution Plan shows the SQL optimizer's query execution path. Execution Plan output is … generated using EXPLAIN PLAN and DBMS_XPLAN. For information about interpreting the output of DBMS_XPLAN, see the Oracle Database Performance Tuning Guide.

SQL Developer User's Guide

SQL Developer Concepts and Usage

Execution PlanThe Execute Explain Plan icon generates the execution plan, which you can see by clicking the … Explain tab. The execution plan is the sequence of operations that will be performed to execute the … statement. An execution plan shows a row source tree with the hierarchy

Database Performance Tuning Guide

Glossary

execution planretrieves rows of data physically from the database or prepares them for the user issuing the statement. You can override execution plans by using hints.

Pro*C/C++ Programmer's Guide

Embedded SQL

Fix Execution Planstored hints and tries to generate an execution plan in accordance with those hints. In this way … parameters affecting the sizes of memory structures. To fix execution plans for SQL's used in Pro*C

Database SQL Language Reference

EXPLAIN PLAN

EXPLAIN PLANPurpose Use the EXPLAIN PLAN statement to determine the execution plan Oracle Database follows to … the work areas used by SQL cursors, query V$SQL_WORKAREA. For information on the execution plan for … execution plan of cached cursors (for example, number of produced

Database Upgrade Guide

Preparing to Upgrade Oracle Database

To bulk load the SQL Management Base with an execution plan from an STSĀ In Oracle Database 10 g Release 2 (10.2), create an STS that includes the execution plan for each … Oracle Enterprise Manager or DBMS_SPM.LOAD_PLANS_FROM_SQLSET to load the execution plans into the SQL … Management Base. Unpacking Existing Oracle Database SQL Plan Baselines from a Staging Table Perform the … g

SQL*Plus User's Guide and Reference

Tuning SQL*Plus

Execution Plan Output in Earlier DatabasesExecution Plan output from Oracle Database 9 i Release 2 (9.2) or earlier is different. Each line … of the Execution Plan has a sequential line number. SQL*Plus also displays the line number of the … parent operation. The Execution Plan consists of four columns displayed in the following

Database Performance Tuning Guide

Designing and Developing for Performance

2.5.5 SQL Execution Efficiency… Parsing is the process of interpreting a SQL statement and creating an execution plan for it. This … process has many phases, including syntax checking, security checking, execution plan generation, and … the application developers understand SQL execution efficiency. To achieve this goal,

Database Performance Tuning Guide

Using EXPLAIN PLAN

12.3 Running EXPLAIN PLANtable. You can then select the execution plan from PLAN_TABLE. See \"Displaying PLAN_TABLE Output\". … To explain a SQL statement, use the EXPLAIN PLAN FOR clause immediately before the statement. For … example: EXPLAIN PLAN FOR SELECT last_name FROM employees; This explains the plan into the PLAN_TABLE

Database Performance Tuning Guide

Using EXPLAIN PLAN

12.1 Understanding EXPLAIN PLANThe EXPLAIN PLAN statement displays execution plans chosen by the optimizer for SELECT, UPDATE … , INSERT, and DELETE statements. A statement execution plan is the sequence of operations that the … database performs to run the statement. The row source tree is the core of the execution plan.

Database Performance Tuning Guide

Using EXPLAIN PLAN

12.1.4 EXPLAIN PLAN Restrictionsthe real execution plan. From the text of a SQL statement, TKPROF cannot determine the types of the … Oracle Database does not support EXPLAIN PLAN for statements performing implicit type conversion of … date bind variables. With bind variables in general, the EXPLAIN PLAN output might not represent

Database Performance Tuning Guide

Instance Tuning Using Performance Views

10.4.1 SQL Plan Monitoringbeing monitored; each entry will correspond to an operation in the execution plan of the statement. … Real-time SQL monitoring also includes monitoring statistics for each operation in the executionplan of the SQL statement being monitored. This data is visible in the V$SQL_PLAN_MONITOR view … statement is

Database Performance Tuning Guide

Using EXPLAIN PLAN

12.1.3 Looking Beyond Execution PlansThe execution plan operation alone cannot differentiate between well-tuned statements and those … execution plan of a SQL statement: After the statement has executed, you can display the plan by … querying the V$SQL_PLAN view. V$SQL_PLAN contains the execution plan for

Database Performance Tuning Guide

Using EXPLAIN PLAN

12.9.3 Examples of Partial Partition-Wise Joins| | | | | | ------------------------------------------------------------------------------------------------------------ The execution plan shows that the table dept2 is … ; ALTER TABLE emp_range_did PARALLEL 2; EXPLAIN PLAN FOR SELECT /*+ PQ_DISTRIBUTE(d NONE PARTITION … Partition-Wise Join with Composite Partition ALTER TABLE emp_comp