Spotlight on Oracle 10.6

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Spotlight on Oracle 10.6 - Release Notes

New Features Resolved Issues and Enhancements Deprecated Features Known Issues System Requirements Product Licensing Getting Started Globalization About us Copyright

Isolate and Tune Problem SQL

The SQL & Application Workload Drilldown allows you to identify the SQL that is consuming the most resources on your system. Tuning this SQL can be one of the most effective ways of tuning your database.

This section contains guidelines on SQL tuning.

Indexing
Use Concatenated Indexes
Take Advantage of The Cost-Based Optimizer
Avoid Accidental Table Scans
Optimize Necessary Table Scans
Use Array Processing

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Spotlight on Oracle 10.6 - Release Notes

Isolate and Tune Problem SQL