Description of the illustration spa.gif

The SQL Performance Analyzer page is shown.

At the top of the page, the following text appears: Page Refreshed May 1, 2012 5:29:47 PM PDT. The Refresh button is to the right of the text. The View Data list is to the right of the Refresh button. "Real Time: 15 Second Refresh" is selected.

The following text appears: "SQL Performance Analyzer allows you to test and to analyze the effects of changes on the execution performance of SQL contained in a SQL Tuning Set."

The "SQL Performance Analyzer Workflows" section follows. The first sentence is: "Create and execute SQL Performance Analyzer Task experiments of different types using the following links."

6 links with associated descriptions follow:

• The Upgrade from 9i or 10.1 link has the following description: "Test and analyze the effects of database upgrade from 9i or 10.1 on SQL Tuning Set performance."

• The Upgrade from 10.2 or 11g link has the following description: "Test and analyze the effects of database upgrade from 10.2 or 11g on SQL Tuning Set performance."

• The Parameter Change link has the following description: "Test and compare an initialization parameter change on SQL Tuning Set performance."

• The Optimizer Statistics link has the following description: "Test and analyze the effects of optimizer statistics changes on SQL Tuning Set performance.

• The Exadata Simulation link has the following description: "Simulate the effects of a Exadata Storage Server installation on SQL Tuning Set performance."

• The Guided Workflow link has the following description: "Create a SQL Performance Analyzer Task and execute custom experiments using manually created SQL trials."

The SQL Performance Analyzer Tasks table follows. The table has the following columns: Select, Name, Owner, Last Modified, Current Step Name, Type, Last Run Status, SQLs Processed, and Steps Completed.

End of description.