Icon of program: Graphical Execution Plan …

Graphical Execution Plan Viewer for Windows

Download now

Used Graphical Execution Plan Viewer for Windows?

Editors’ Review

Download.com staff
Epviewer provides a graphical interface for Oracle execution plans, making complex queries easier to understand than standard tabular views. It highlights performance bottlenecks effectively.
Enlarged image for Graphical Execution Plan …
Graphical Execution Plan Viewer 0/1

  • Pros

    • Graphical display of Oracle execution plans
    • Easier to read than tabular representations
    • Displays filter and access predicates directly
    • Shows actual execution statistics alongside estimates
    • Highlights expensive operations for quick analysis

  • Cons

    • Supports only Oracle 10g and 11g
    • Configuration changes may require reinstallation or registry edits
    • User preference changes are not intuitive
Icon of program: Graphical Execution Plan …

Graphical Execution Plan Viewer for Windows

Download now

Used Graphical Execution Plan Viewer for Windows?

Explore More

Full Specifications

GENERAL
Release
Latest update
Version
2.0
OPERATING SYSTEMS
Platform
Windows
Operating System
  • Windows 10
  • Windows XP
  • Windows Vista
  • Windows 8
  • Windows 2000
  • Windows NT
  • Windows 7
Additional Requirements
JRE 1.5 or later, GraphViz
POPULARITY
Total Downloads
245
Downloads Last Week
1
Report Software

Program available in other languages

Last Updated

Developer’s Description

By Tilo Hegel
Generate and view Oracle Execution (Explain) Plan in a graphical form.
The Graphical Execution Plan Viewer for Oracle Databases version 10g and 11g (epviewer) is a Java based executable dialog program for generating and displaying of the Oracle Execution (Explain) Plan in a graphical form. The Graphical Execution (Explain) Plan is much easier to read and to understand than the tabular executing plan representation provided by the Oracle function DBMS_XPLAN.DISPLAY. In the tabular representation it is difficult to understand the execution order for the various steps especially for a complex execution plan. In the graphical execution plan using epviewer filter and access predicates are displayed into the operation step information directly; in the tabular execution plan these predicates are referenced by an operation id link. Epviewer can display V$SQL_PLAN_STATISTICS_ALL data, that contains beside the estimated values real execution values from the last execution too; I think, there exists no equivalent DBMS_XPLAN.DISPLAY function for displaying these V$SQL_PLAN_STATISTICS_ALL data. With epviewer you are able to create an execution plan from various plan table sources (V$SQL_PLAN_STATISTICS_ALL including V$SQL_PLAN, STATS$SQL_PLAN(_USAGE), DBA_HIST_SQL_PLAN, plan_table for the Complete SQL Input) for a given SQL_ID or Hash Value.Epviewer highlights the most expensive operations/ nodes. If row source execution statistics are available, epviewer highlights the nodes with expensive real/ last elapsed times, otherwise epviewer highlights the nodes with the expensive estimated times. So you see very fast and very rapidly which steps of the execution plan are most expensive especially if the Execution plan contains many nodes.Epviewer is an user friendly interface, that loads and saves the user preferences (like ip address, user etc.). If you want to change the first time configurations, you may install the program again or change the preferences in HKEY_CURRENT_USER/Software/JavaSoft/Prefs/epviewer using regedit.To zoom in and out of the Execution plan image file in the new window use the mouse scroll wheel and to navigate inside of the Execution plan use the mouse and the navigation image located in the upper left corner of the panel.More informations in http://www.epviewer.bplaced.net/wp-content/uploads/2012/01/Readme_epviewer.pdf
Download.com
Your review for Graphical Execution Plan Viewer