Chat now with support
Chat with Support

Spotlight on Oracle 10.10 - 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 Troubleshooting: Connection Problems

Tools | SQL Optimizer

SQL Optimizer provides context-sensitive tuning advice for SQL statements based on the Oracle execution plan and the database structure.

Note: In earlier versions of Spotlight on Oracle, SQL Optimizer was also known as SQLab or SQL Tuning.

Before you open SQL Optimizer

  • Ensure SQL Optimizer is installed on your machine.
  • Ensure you have DBA privileges for the database you are diagnosing.

Ways to open SQL Optimizer

Location Instruction
From anywhere in Spotlight.

Click Tools | SQL Optimizer.

From Drilldown Pages:

Click .

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating