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
Upload SQL tables to Amazon SimpleDB Upload SQL table to SimpleDB is an application to export your SQL table data into SimpleDB. Features include upload SQL Server tables to Amazon SimpleDB domains and create a SimpleDB domain per SQL table and upload table data to the SimpleDB domain.
PowerDBTools PowerDBTools is a tool based on Microsoft OLE DB technologies to help developers and database administrators develop, manage and maintain their databases. It is the perfect solution since the same tool can be used on all major operating systems accessing a
My Club My Club can have association and a small business. This software lets you create and manage a list of clients, members. Create and manage membership, loyalty cards. To create and manage quotes, invoices. With its advanced planning system for multiple uses,
DocHopper Share, preview and backup information on your Computer Network using DocHopper, a Knowledge Management software ideal for small and big companies. DocHopper was designed for all types of organizations managing on a daily basis a large amount of documents o
MsSqlToExcel MsSqlToExcel is Convenient and easy visually config just click on the mouse. It is displaying time estimation and session parameters. It Support xls and xlsx (Excel 2007). It can export from both table and query. Also can export all tables data to files at
DBConvert for Access & MS FoxPro DBConvert for MS Access & MS FoxPro is a database migration tool for data conversion from MS Access to MS FoxPro and from MS FoxPro to MS Access databases. You can convert MS Access data to MS FoxPro or MS FoxPro to MS Access databases simply by configurin
Deniz SQL Multi Script Very often DBA needs to deploy a bunch of transact-sql scripts to multiple servers. Deniz SQL Multi Script give you the ability to run a single script on multiple databases across multiple servers in a single go.Limitations:14-day trial
DB Organizer Deluxe DB Organizer Deluxe is a program that allows users to organize, catalog, and manage virtually any type of information. The program is intuitive and easy-to-use for the beginner, while feature-rich and powerful enough to satisfy the most advanced users. Rea
QueryToDoc Export Query Results to Excel, Word, or HTML. Use QueryToDoc to export Oracle and SQL Server query results to an Excel, Word, HTML, CSV file. Write a SQL query against an Oracle or SQL Server database, view the results, and then automatically export the qu
Citrus Replay Community Edition All the features of our Professional Edition, but limited to MySQL and Firebird databases. Connect to and browse your databases using native connections. No other drivers or other downloads needed. Create queries quickly with syntax highlighting and drag &
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