Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - 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

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