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
Excel to MySQL Smart Converter Excel to MySQL Smart Converter can save your time and effort by converting any MS Excel sheet directly to MySQL format, this smart tool can handle all version of MS Excel and MySQL, you can choose to save the result data to a .SQL dump file or to transfer
HeidiSQL HeidiSQL is a lightweight, Windows based interface for MySQL databases. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard
Win Data Recovery Free Win Data Recovery Free is a comprehensive data recovery software to recover data on major windows operating system. It recovers files emptied from the Recycle Bin, lost due to hard drive crash, formatted or damaged hard drive, virus infection and other unk
K9 Bytes Koordinator The K9 Koordinator was designed to efficiently and easily manage scheduling, clients, pet information, services, and retail information.
Who can use K9 Koordinator?
K9 Koordinator users include pet resorts, boarding kennels, grooming shops, mobile
Contribution Keeper Contribution Keeper takes the 'work' out of record keeping. Especially for the treasurer of your organization. Easily keep track of weekly and/or other contributions. Store detailed information on each contributor. Include Photo of contributor. Print 'End
Tukanas Link Extractor Tukanas Link Extractor can quickly extract links, URLs, emails from files and folders. Extract customer data, transaction data, sales data, and order data from files. Search and extract ftp, http, gopher, https, emails, news, telnet, wais, phones, and fax
NoSQLt Tool As the maintenance and management tool of NoSQLt Server, NoSQLt Tool can easily do the complete maintenance and management of the database server through the graphical interface and humanized operation on the local server or on the far end. Its main functi
Excel PostgreSQL Import, Export & Convert Software This software offers a solution for database users who need to use MS Excel as a front-end interface to a PostgreSQL database. Use Excel to import and export tables between a PostgreSQL database without SQL knowledge. This software will save you hours of t
Visual Studio 2005 Automation Samples These code samples show you how to build VSMacros projects, add-ins, and wizards to make your teams more productive and to customize Visual Studio 2005 to the ways you like to work. This version is the first release on CNET Download.com.What is new in this
Viobo MSSQL to MySQL Converter Professional Portable Viobo MSSQL to MySQL Converter tool is the simplest data-converter between MSSQL and MySQL currently. It converts data between MSSQL and MySQL database system accurately and perfectly, with NO database administrator experience required. The tool is compati
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