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. 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 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 data. With epviewer you are able to create an execution plan from various plan table sources, 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 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.
- 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
How To Install?1: Download the software from the given link.
2: Unpack and install the software.
3: Copy the crack directory crack file in the installation directory.
4: After that, open the program and click the button to enter the serial Key.
5: After that, open your keygen as administrator and select patch.
6: Then open the program and enter offline mode.
7: It's all done.