Oracle Database - DBMS_XPLAN

Card Puncher Data Processing

About

Dbms_xplan is a method for:

It displays:

  • the SQL execution plan (VSQL_PLAN)
  • and SQL execution runtime statistics for cached SQL cursors (VSQL_PLAN_STATISTICS_ALL)
  • plans from a SQL plan baseline.

It includs the supplemental information at the bottom of the report (new in Oracle9i release2)

Syntax

Display

to format and display the contents of a plan table. The query :

Select * From table( dbms_xplan.display)

Will perform the same function than the @?rdms\admin\utlxpls.sql

Actual Plan

Using it with the VSQL_PLAN dynamic performance view, we can easily dump the query plans for already executed statements, directly from the database : Actual Plan with DBMS XPLAN

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Database - Explain Plan

EXPLAIN PLAN is an Oracle SQL Command that tell you what the query plan for a given SQL would be : if executed it right now in the current session with the current settings For this purpose, it...
Query Plan For The Same Query Response Time
Sql Engine - (Physical|Execution) Plan

A physical plan (or execution plan) is an ordered tree of physical relational operator that represent the execution a query A logical plan is also a ordered tree of relational operator but without the...



Share this page:
Follow us:
Task Runner