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
Sybase iAnywhere Sybase ASE Import, Export & Convert Software This software offers a solution to the users who want to transfer tables between Sybase iAnywhere and Sybase ASE databases. The user simply enters the login information for the Sybase ASE database, enters the data source and tests both connections before p
Oracle Delete Duplicate Entries Software This software offers a solution to users who want to delete duplicate entries in Oracle tables. The user simply enters the login information for the required database and tests the connection before using the following user-friendly interface to specify fi
ABC Amber DBX Converter ABC Amber DBX Converter is intended to help you convert Outlook Express databases (DBX files) to DBF or CSV format easily and quickly. All you have to do is select required messages, choose format to convert and click "Save As" button. Currently our softwa
ParadoxRecovery ParadoxRecovery is powerful data recovery software for damaged Paradox database files (.DB). It is easy-to-use tool for database recreation and recovers tables and table data. Creates new .DB files and writes recovered information there. Supports file vers
Oracle Remove Text, Spaces & Characters From Fields Software This software offers a solution to users who want to delete or replace specific data from an Oracle database. The user simply enters the login information for the database and tests the connection before proceeding to the user-friendly interface to specify
My Data on the Web My Data on the Web is a fast, easy reliable way to create an application to manage your data on your workstation, your home or office network or on the public Internet. It's as simple as 1, 2, 3 - Go! 1.Create your data definitions using simple terms - no
SmartLog Industrial weighment SmartLog is a leading Industrial weighment software application used in highly complex industrial inventory and management requirements to simple ticketing.
Smartlog Industrial weighment software is used for connecting to one or more industrial scales
EMS SQL Manager for InterBase/Firebird EMS SQL Manager for InterBase/Firebird is a powerful tool for InterBase and Firebird database administration and development.
SQL Manager is compatible with any InterBase and Firebird database management systems version up to the newest one and supports a
ChemDB ChemDB, a chemical information database. Contains emergency response guide, initial isolation and protective action distances, chemical reactivity database, chemical intrinsic properties, chemical information and safetydata, gamma library database, MSDS di
DB2-to-MySQL DB2-to-MySQL is a program to migrate DB2 database to MySQL server. Features include where all versions of DB2 servers are supported, all versions of Unix and Windows MySQL servers are supported, option to convert individual tables, option to convert partia
Supported Operating Systems:
Windows 2000 |
Windows 7 |
Windows 8 |
Windows NT |
Windows Vista |
Windows XP |
Comments on :
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