Specifying Default Values for SPA Quick Check

You specify default settings for SPA Quick Check on the SQL Performance Analyzer Setup page in Cloud Control.

To specify default settings for SPA Quick Check:

  1. On the Database Home page in Cloud Control, from the Performance menu, select SQL, then SQL Performance Analyzer Setup. If the Database Login page appears, enter administrator privileges for the database, then click Login.The SQL Performance Analyzer Setup page appears.
    Description of the illustration sqc_setup_page.png follows
    Description of the illustration sqc_setup_page.png

  2. Configure the settings for the SPA Quick Check feature, which is available on some Cloud Control database management pages. The SQL tuning set that you specify should be representative of the workload for the application that you want to tune.

  3. Click Save to save the default SPA Quick Check settings you specified.