Available now: SQL Tuning Advisor for Oracle Cloud Databases

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s