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
Database Lookup This application was originally built as a support tool to assist when deploying .net applications when tools like Management Studio are not available. Some of the functions include Support for SQLConnection and OleDbConnecton. This is automatic selected
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
Visual Importer ETL Enterprise (32-bit) Visual Importer ETL Enterprise is a platform for building high performance data integration solutions, Including extraction, transformation, and load (ETL) packages for data warehousing and business automation. Visual Importer ETL Enterprise includes graph
MindModel MindModel is a very easy-to-use relational database software that allows you to store and recall information on any topic.
Use it to create databases of people, companies, products, ideas, or anything else, all without programming.
Since it's truly r
Access 2007 Sample: Ribbon Extensibility in Access 2007 Access 2007 Sample: Ribbon Extensibility in Access 2007 contains the Marketing Projects database, which shows how to track time-sensitive deliverables and vendor status for projects. It accompanies the article, Ribbon Extensibility in Access 2007. The data
Absolute Media Library Absolute Media Library is a database program for cataloging and tracking collections of all types of physical media such as Books, CDs, DVDs, or virtually any format you can think of. Abs also tracks people who you lend items to, keeps inventory, and can g
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
Job Start Do you have a need to run SQL Server jobs on demand?
Job Start gives users the ability to run jobs on demand from their own PC. Any jobs (including database backups and scheduled jobs) that have been setup on SQL Server can be invoked by Job Start users
Recovery for FileMaker Recovery for FileMakeris is data recovery software for damaged FileMaker Pro database files (.FP*). Recovers tables and table data. Stores recovered information into common .DBF format, compatible with many database applications. New integrated data recove
Microsoft Access Calendar Form Template On this microsoft access calendar form database, you can add specific daily events on the calendar with detailed start time and end time for each event. You can sort month and year from period January 2011 - December 2020, and then fill the database within
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