X

Join or Sign In

Sign in to add and modify your software

Continue with email

By joining Download.com, you agree to our Terms of Use and acknowledge the data practices in our Privacy Policy.

Developer's Description

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 report, which is more easier to read and to understand, than the Statspack report from Oracle produced by Statspack spreport.sql. Furthermore the pviewer (in opposite to the original Statspack report from Oracle) contains the complete SQL text, the graphical explain plan for the high impact SQLs, interpretation hints as well as recommendations and also unshortened and easy copyable result values. Why pviewer? Statspack generates with the script spreport.sql a report text file using performance data stored in the Statspack repository. This is partially done with line breaks inside of the report parts, incomplete SQL text and incomplete other values. Unfortunately sometimes you may see ####### for values, which are too large for the specific Statspack report field--but therefore even very important. Pviewer always displays the complete values and reports as well as the complete SQL text.

Pviewer generates a modern style HTML report similar to the AWR report, which is easier to read and to understand as the Original Statspack report produced by Statspack spreport.sql. Pviewer is a Java Windows client dialog program and therefore much easier to handle and to use, than the original Statspack report generation. In general pviewer contains more data from the Statspack tables - that means more columns and more rows. Pviewer contains a new important statistic with the Top SQL's ordered by high impact additionally: Top n SQLs (configured with TOP_SQL_HIGH variable) using stats$sql_summary, STATS$SQLTEXT (v$sql, v$SQLTEXT as basis tables) ordered by high impact (BUFFER GETS, CPU TIME and ELAPSED TIME) desc. And for each high impact SQL there is a lot of information available - and the Graphical execution plan in epviewer format is displayed. For the advantages of the Graphical execution plan in epviewer format see Readme_epviewer. Furthermore the pviewer (in opposite to the original Statspack report from Oracle) contains interpretation hints as well as recommendations and also unshortened and easy copyable result values.

Full Specifications

What's new in version 3.0

Version 3.0:
  • Bugfixes from version 2.0

General

Release January 8, 2013
Date Added January 7, 2013
Version 3.0

Operating Systems

Operating Systems Windows Vista, Windows, Windows NT, Windows 2000, Windows 8, Windows 7, Windows XP
Additional Requirements JRE (Java Runtime Environment) 1.5 or later, GraphViz

Popularity

Total Downloads 126
Downloads Last Week 0
Report Software

Related Software

Microsoft Office Access 2010

Free to try
Microsoft Office Access 2010

CSV Viewer

Free
CSV Viewer

Inventory Management System for Small Business in Access Templates

Free
Inventory Management System for Small Business in Access Templates

FileMaker Pro

Free to try
FileMaker Pro