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 statements2. analyze query using RDBMS tools3. locate corresponding query in the log4. trace slow operations5. tune query by re-composition or adding indexes
B. 1. trace slow operations2. identify long-running queries and statements3. locate corresponding query in the log4. analyze query using RDBMS tools5. tune query by re-composition or adding indexes
C. 1. tune query by re-composition or adding indexes2. locate corresponding query in the log3. trace slow operations4. identify long-running queries and statements5. analyze query using RDBMS tools
D. 1. locate corresponding query the session log2. analyze query using RDBMS tools3. tune query by re-composition or adding indexes4. identify longrunning queries and statements5. trace slow operations
|
Download Printable PDF. VALID exam to help you PASS. |
 |