July 22, 2008 - Quest Software, Inc. announced the addition of predictive diagnostics to its Spotlight on Oracle product. The new predictive capabilities extend allow users to predict the future performance of SQL statements.

 

Spotlight on Oracle analyzes SQL performance to determine which statements will have the most performance degradation given trends in execution rates and overall database load. Spotlight reports the anticipated growth in resource consumption and the percentage of the total load a particular statement will consume. By finding problematic SQL statements before performance is impacted, corrective actions can be taken without disrupting end users and organizations can more effectively meet end-user Service Level Agreements.  

 

Spotlight on Oracle also has expanded diagnostic capabilities for Oracle Real Application Cluster (RAC) environments. With new RAC service diagnostics in Spotlight, database administrators can see how each service is distributed across the cluster’s nodes and what resources are being consumed on each node by the various services.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access