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
What is new in this release:
As one important new feature epviewer calculates and displays the Elapsed node time (estimated and real) which contains only the Elapsed time of the actual operation without the elapsed time for the child nodes. Therefore epviewer can highlight expensive operations and you see very fast and very rapidly which steps of the execution plan are most expensive.
Another new feature is the easy possibility to interactive zoom in and out of the Execution plan using the mouse scroll wheel and to navigate inside of the Execution plan.
bugfixes of version 1.0
JRE 1.5 or later, GraphViz
Like it? Share with your friends!
Other Windows Software of Developer «Tilo Hegel»:
Performance Viewer The Performance Viewer for Oracle Databases version 10g and 11g (pviewer) is a Java based executable dialog program for viewing/ displaying Oracle performance data, that are collected and stored by Oracle Statspack. Pviewer generates a modern styled HTML r
EMS DB Extract for DB2 EMS DB Extract for DB2 is an impressive and easy-to-use tool for creating DB2 database backups in a form of SQL scripts. This database script utility allows you to save metadata of all DB2 database objects as well as DB2 table data as database snapshot. DB
FoxPro Sybase iAnywhere Import, Export & Convert Software This software offers a solution to users who want to transfer tables to and from FoxPro and Sybase iAnywhere databases. The user simply chooses the DBC file or a folder containing multiple DBC files for the required FoxPro database and enters the Sybase iA
Advanced Access Password Recovery Advanced Access Password Recovery can quickly recover passwords for your Access 95/97 database. It can also remove the password protection from the database, as well as change your password. Version 2.5 has better support for Access 2000, the ability to co
MS Access Import Multiple XML Files Software This software offers a solution for users who want to load one or more XML files into an MS Access database. There are features to import each XML file to its own table or import all XML files to one table.Requirements:Microsoft Access XPLimitations:Limite
GoldFish.Net GoldFish.Net is a way to develop, manage, and maintain your Oracle databases. This Charityware application offers an ever expanding set of features such as a Schema Browser with QuickEdit functionality allowing you to update your application code within a
Vehicle Manager Enterprise Edition Vehicle Manager is an application to track your vehicle's service schedule and service history. Vehicle Manager allows you to create a service schedule for each vehicle as well as maintaining the history of all services for each vehicle. You will be remind
OpenLink Multi-Tier Edition ODBC Driver High-Performance ODBC Drivers provide transparent access to remote databases from any ODBC-compliant application. Desktop Productivity Tools (i.e., Spreadsheets, Word Processors, Presentation Packages, Desktop Databases, Personal Organizers, etc.), Client-
CentriQS CentriQS is single integrated business management software that centralizes your company data, resources, operations and core business functions into all-in-one solution customized for your specific requirements and industry-related needs. Start using Cent
DeZign for Databases DeZign for Databases is an intuitive database design tool for developers and DBA's that can help you model, create and maintain databases. DeZign for Databases uses entity relationship diagrams (ERDs) to graphically design databases and automatically gener
Supported Operating Systems:
Windows 2000 |
Windows 7 |
Windows 8 |
Windows NT |
Windows Vista |
Windows XP |
Comments on Graphical Execution Plan Viewer:
Comments not found
Windows Software - Free Windows Downloads, Apps, Games, Freeware, Skype, Media Player, Antivirus, Gimp, Live, Starter for Windows XP, Vista, 7, 8, 10