SQL Tuning for maximizing Oracle Database performance
Tuning usually implies fixing performance problems. However, tuning should be part of the life cycle of an application—through the analysis, design, coding, production, and maintenance stages.
An important facet of database system performance tuning is the tuning of SQL statements. SQL tuning involves three basic steps:
• Identifying high load or top SQL statements that are responsible for a large share of the application workload and system resources, by reviewing past SQL execution history from the system.
• Verifying that the execution plans produced by the query optimizer for the statements perform reasonably.
• Implementing corrective actions to generate better execution plans for poorly performing SQL statements.
Read the complete article by Sriram Vrinda