You receive an application from the development department, and you detect there is a new issue
causing poor performance.
Which application tuning sequence is correct?
A.
1. identify long-running queries and statements
2. analyze query using RDBMS tools
3. locate corresponding query in the log
4. trace slow operations
5. tune query by re-composition or adding indexes
B.
1. trace slow operations
2. identify long-running queries and statements
3. locate corresponding query in the log
4. analyze query using RDBMS tools
5. tune query by re-composition or adding indexes
C.
1. tune query by re-composition or adding indexes
2. locate corresponding query in the log
3. trace slow operations
4. identify long-running queries and statements
5. analyze query using RDBMS tools
D.
1. locate corresponding query the session log
2. analyze query using RDBMS tools
3. tune query by re-composition or adding indexes
4. identify long-running queries and statements
5. trace slow operations