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
Kennel Connection Kennel Connection is software for the pet care industry, featuring boarding, grooming, daycare, training and petsitting modules as well as the new special services module.
Kennel Connection 6.0 can retire that old calendar and make all of your other tas
Stellar Phoenix DB2 Database Recovery Software Stellar Phoenix DB2 Database Recovery Software repairs and recovers corrupted DB2 database recovers triggers, tables, schemas, views, containers and buffer pools.You can restore damaged DB2 files after instances of databse header corruption,Application Ma
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
Invantive Query Tool Free Real-time Operational Intelligence
Invantive's free Query Tool provides you with real-time Operational Intelligence (OI) across your entire enterprise. The free Query Tool provides access to your real-time data warehouse and databases running on My
Paradox IBM DB2 Import, Export & Convert Software This software offers a solution to users who want to transfer tables between Paradox and IBM DB2 databases. The user simply chooses the Paradox folder, enters the login information for the IBM DB2 database and tests both connections before proceeding to th
Seismic Toolkit Seismic Toolkit offers several modules, which provide valuable help in segy data loading and editing. Software allows conversion of segy file trace header coordinates from one datum to another datum and/or from one UTM zone to another one. Over 200 datums
adminApp adminApp is a client side application written in Java that gives you spread sheet support to your MySQL database and requires no drivers. One of the major factors in running web sites today is the accessibility and ease of manipulation of your databases. T
DBF to HTML The DBF to HTML program allows you to convert your DBF files to HTML pages. It allows you to create a single page or many pages with a navigation bar. Besides, you can define such parameters as border width, cellspacing, or cellpadding. The program support
Cervical Exam Form - Sample Computer Fillable Medical PDF Forms. Patient records can be typed, e-mailed, saved and stored on your computer. Easy access and retrieval! We can take your existing forms and make them electronic fillable forms. Your own company logo, address and phone num
Data Masking Suite Data Masking Suite- simple to install, flexible, and self-explanatory.
Create test data and mask sensitive data.
Data Masking Suite contains all you need for fast and reliable Data Masking.
Orpheus Data Masking Suite is exceptionally easy to use. Try
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