Publisher's description
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.
As one important new feature pviewer calculates and displays inside of the Graphical execution plan for the high impact SQLs the Estimated elapsed node time which contains only the Elapsed time of the actual operation without the elapsed time for the child nodes. Therefore pviewer highlights expensive operations and you see very fast and very rapidly which steps of the execution plan of the high impact SQLs are most expensive.
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.
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 contains interpretation hints as well as recommendations and also unshortened and easy copyable result values.
For more details see http://www.epviewer.bplaced.net/wp-content/uploads/2012/01/Readme_pviewer.pdf
As one important new feature pviewer calculates and displays inside of the Graphical execution plan for the high impact SQLs the Estimated elapsed node time which contains only the Elapsed time of the actual operation without the elapsed time for the child nodes. Therefore pviewer highlights expensive operations and you see very fast and very rapidly which steps of the execution plan of the high impact SQLs are most expensive.
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.
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 contains interpretation hints as well as recommendations and also unshortened and easy copyable result values.
For more details see http://www.epviewer.bplaced.net/wp-content/uploads/2012/01/Readme_pviewer.pdf
User comments