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
Property Management Software Our property management software is a Microsoft Access based database software for rental or properties management. This property management software include: property information manager, property leasing documents management, property rental tracking, te
Excel Sybase ASE Import, Export & Convert Software This software offers a solution to users who want to use Excel as a front-end interface for a Sybase ASE database. The software installs as an add-in in Excel. The new menu option in Excel allows setting up of a database connection and various import and e
Excel Add-In for Google Analytics The Google Analytics Excel Add-In is a powerful tool that allows you to connect with live data from Google Analytics, directly from Microsoft Excel. Use Excel to access all kinds of real-time site traffic and analysis data. Perfect for mass imports / expor
Ultra Recall Professional Ultra Recall is a personal information/knowledge management application for Microsoft Windows. It helps you capture, organize, and recall all of your electronic information across all the applications that you use. Existing PIMs tend to be either too simp
Recovery for SQL Server Recovery for SQL Server recovers damaged Microsoft SQL Server database files (.MDF or .NDF). It creates Transact-SQL script that re-creates the database from the scratch. Recovery for SQL Server is able to recover corrupted tables, views, stored procedures
Stellar Phoenix Access Password Recovery Stellar Phoenix Access Password Recovery 1.0 is an excellent Microsoft Access password recovery tool that recovers Access password from the Access databases. Supporting password recovery in MS Access 97, 2000, 2002, 2003, and 2007, this Access password rec
MS SQL Server Upload or Download Binary Data Software MS SQL Server Upload or Download Binary Data Software is for users who need to put binary data in MS SQL databases. The user friendly interface of this application guides you from start to finish quickly and clearly. Simply enter the server address and sel
MDB Converter Using the MDB Converter you can easily and quickly convert large MDB files to text or CSV files. Just choose the file to convert and you are just two clicks away from your desired file. The MDB Converter has been especially built and tested for extra large
MS SQL Server Extract Data & Text Software MS SQL Server Extract Data & Text Software extracts fields (columns) containing specific text in MS SQL Server databases. Extract parts of a field by specifying starting and ending character(s). Extractions are executed on all tables in the database.Requir
Gym POS Manager Gym POS Manager is a versatile software for those who operate fitness centers. Enjoy this user-friendly software. Just click on buttons to navigate from file to file. Managing billing, memberships and appointments have never been so easy. Spend your time w
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