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 4487 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


Database Administrator's Guide, 12c Release 1 (12.1)

Developing Applications for a Distributed Database System

33.4.4 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 … SQL Tuning Guide for detailed information about execution plans, the EXPLAIN PLAN

Database SQL Tuning Guide, 12c Release 1 (12.1)

Reading Execution Plans

Execution Plan ReferenceThis section contains the following topics: Execution Plan Views PLAN_TABLE Columns DBMS_XPLAN Program Units

Database SQL Tuning Guide, 12c Release 1 (12.1)

Reading Execution Plans

Execution Plan Views… Table 7-4 Execution Plan Views View Description V$SQL_SHARED_CURSOR Explains why a particular child … The following dynamic performance and data dictionary views provide information on execution plans … . PLAN_LINE_ID is consecutively numbered, but for a single final plan, the IDs may not be consecutive

Database SQL Tuning Guide, 12c Release 1 (12.1)

Generating and Displaying Execution Plans

Displaying an Execution Plan: Exampletable shows the execution plan that the optimizer chose to execute the SQL statement in Example 6-3 … Example 6-3 uses EXPLAIN PLAN to examine a SQL statement that selects the employee_id, job_title … PLAN EXPLAIN PLAN FOR SELECT e.employee_id, j.job_title, e.salary, d.department_name FROM employees

Database Concepts, 12c Release 1 (12.1)

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 a hint.

Database Installation Guide for Linux, 12c Release 1 (12.1)

Configuring Users, Groups and Environments for Oracle Database

5.6 Determining Root Script Execution PlanOwner\" 5.6 Determining Root Script Execution Plan During an Oracle Grid Infrastructure installation … during installation. See Also: Step 9, \"Root Script Execution Configuration\" screen in the

SQL*Plus User's Guide and Reference, 12c Release 1 (12.1)

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.

Database SQL Tuning Guide, 12c Release 1 (12.1)

Glossary

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

Database SQL Tuning Guide, 12c Release 1 (12.1)

Optimizer Statistics Concepts

In automatic reoptimization, the optimizer changes a plan on subsequent executions after the initial…preceding query. The following example shows the execution plan (sample output included): SELECT * FROM … statistics from this initial execution to determine the plan. The database persists the information … database will hard parse it again, and then generate a plan based on the previous execution

SQL Developer User's Guide, 12c Release 1 (12.1)

SQL Developer Concepts and Usage

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

Pro*C/C++ Programmer's Guide, 12c Release 1 (12.1)

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, 12c Release 1 (12.1)

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 SQL Tuning Guide, 12c Release 1 (12.1)

Query Optimizer Concepts

In Oracle Database, adaptive query optimization is the process by which the optimizer adapts an execution…execution. An optimizer statistics collector is a row source inserted into a plan at key points to … How Adaptive Query Plans Work An adaptive plan contains multiple predetermined subplans, and an … optimizer statistics collector. A subplan is a portion of a plan that the optimizer can switch to as an … multiple

Database SQL Tuning Guide, 12c Release 1 (12.1)

Query Optimizer Concepts

In Oracle Database, adaptive query optimization is the process by which the optimizer adapts an execution…executions after the initial execution. Adaptive query plans are not feasible for all kinds of plan … from optimizer estimates, then the optimizer looks for a replacement plan on the next execution. The … Automatic Reoptimization In automatic reoptimization, the optimizer changes a plan on subsequent

Database SQL Tuning Guide, 12c Release 1 (12.1)

Query Optimizer Concepts

In Oracle Database, adaptive query optimization is the process by which the optimizer adapts an execution…section of the execution plan indicates whether the plan is adaptive, and which rows in the plan are … different plan based on information collected at runtime. The following query shows a join of the … AND quantity > 1 AND p.product_id = o.product_id An adaptive query plan for this

SQL*Plus User's Guide and Reference, 12c Release 1 (12.1)

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

Grid Infrastructure Installation Guide for Oracle Solaris, 12c Release 1 (12.1)

Configuring Users, Groups and Environments for Oracle Grid Infrastructure and Oracle RAC

5.5 Determining Root Script Execution PlanDuring Oracle Grid Infrastructure installation, the installer requires you to run scripts with superuser (or root ) privileges to complete a number of system configuration tasks. You can continue to run scripts manually as root, or you can delegate to the installer the privilege to run configuration steps as root, using one of the following options: Use the root password: Provide the password to the

Grid Infrastructure Installation Guide for HP-UX Itanium, 12c Release 1 (12.1)

Configuring Users, Groups and Environments for Oracle Grid Infrastructure and Oracle RAC

5.4 Determining Root Script Execution PlanDuring Oracle Grid Infrastructure installation, the installer requires you to run scripts with superuser (or root ) privileges to complete a number of system configuration tasks. You can continue to run scripts manually as root, or you can delegate to the installer the privilege to run configuration steps as root, using one of the following options: Use the root password: Provide the password to the

Grid Infrastructure Installation Guide for IBM AIX on POWER Systems (64-Bit), 12c Release 1 (12.1)

Configuring Users, Groups and Environments for Oracle Grid Infrastructure and Oracle RAC

5.4 Determining Root Script Execution PlanDuring Oracle Grid Infrastructure installation, the installer requires you to run scripts with superuser (or root ) privileges to complete a number of system configuration tasks. You can continue to run scripts manually as root, or you can delegate to the installer the privilege to run configuration steps as root, using one of the following options: Use the root password: Provide the password to the

Database SQL Tuning Guide, 12c Release 1 (12.1)

Query Optimizer Concepts

Execution PlansAn execution plan describes a recommended method of execution for a SQL statement. The plan shows … . An execution plan displays the cost of the entire plan, indicated on line 0, and each separate … operation. The cost is an internal unit that the execution