Chat now with support
Chat with Support

Spotlight on Oracle 10.5 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

Sample Data

When you start using Predictive Diagnostics on your own Oracle database, Spotlight will take some time (typically, about 10 days) to collect enough data to make valid predictions on the future performance of the database.

In the meantime, you can use some prepared sample data to learn more about Predictive Diagnostics and how it works.

 

How to install Sample data if it is not already installed

If the current Spotlight connection was created initially without installing the sample data for Predictive Diagnostics, you can add the sample data later via Spotlight's Oracle User Wizard.

  1. Close the current Spotlight connection but do NOT exit Spotlight.
  2. Click File | Oracle User Wizard... Click Next on the first User Wizard window.
  3. Type the SQL*Net connection string, user name, and password for the SYS or DBA account on the target database. Click Next.
  4. Click Set up an existing user | Next. A list of available users appears.
  5. Select the user and type the correct password in the User password field. Click Next.
  6. Select Install sample data for Predictive Diagnostics. Click Next.
  7. Change the Predictive Diagnostics settings if you want to. Click Next.
  8. Continue and complete the standard installation procedure.
  9. Re-open the Spotlight connection. You can now access the sample data.

 

Using the sample data

View and analyze sample SQL performance data
  1. Open the Predictive Diagnostics home page.

  2. Click Identify Degrading SQL (SQL Performance).
  3. Open the SQL Statement Trend Analysis Wizard. To do so, click Set SQL Criteria on the SQL Performance page.
  4. Complete the wizard.
    1. On the SQL Statement Data page, select Analyze the sample data...
    2. Complete the rest of the wizard, choosing the criteria that you want to apply to the analysis.
  5. Use the SQL Performance page and its sub-pages to view the analysis.

Note: If you select Don't show this page in future on the SQL Statement Data page, you will no longer be able to analyze the sample data.

View and analyze sample bottleneck data
  1. Open the Predictive Diagnostics home page.

  2. Click Identify Database Bottlenecks (Impending Bottlenecks - Timed Statistics).
  3. From the Perform an Analysis of... list, select Sample Data.
  4. Set the other criteria used to perform the analysis of bottlenecks.
  5. Use Impending Bottlenecks - Timed Statistics and its sub-pages to view the analysis.
View and analyze sample performance modeling data
  1. Open the Predictive Diagnostics home page.

  2. Click Identify the peak-activity periods of the database (Peak Processing Periods).
  3. From the Show database processing activity for... list, select Sample Data.
  4. Set the other criteria used to model database performance.
  5. Return to the Predictive Diagnostics home page.
  6. Use Performance Modeling and their sub-pages to view the analysis.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating