Within the SQL Optimizer for Oracle- Inspect SGA, is there a metric for elapsed time per execution?
The objective to identify the worst performing SQL in an easy to read formatted report.
This report needs various metrics per SQL_ID plus the associated SQL statement for that SQL_ID on a single output line in Excel spreadsheet format.
WORKAROUND (For versions before 9.2.2)
"Elapsed_time per Execution" metric is not available in Inspect SGA.
Regarding saving to an Excel spreadsheet, the product can only save what displayed in the grid now.
The metrics are not saved together with the SQL.
One needs to use the SQL_ID to relocate the SQL Text in the product.
The grid has a built-in function to find a particular value.
In the grid, click Ctrl+F and enter the SQL_ID to find the row.
The request SOFO-2054 references to allow saving the SQL Text with the metric in one Excel spreadsheet.
RESOLUTION
This feature has been included in SQL Optimizer for Oracle version 9.2.2.
Download the current version here.
