A. DSS environment prefer a large block size.
A. Poor application design that does not make good use of indexes.
B. Applications not written to use bind variable to take advantage of shared SQL statements.
C. Poor application design that require too many tables to be joined together to resolve queries.
D. Applications not closing cursors in a timely fashion because the init.ora parameter OPEN_CURSORS was set too high.
Answer: A, B, D
Explanation:
All these reasons can explain poor database performance.
Incorrect Answers
C: Number of tables that need to be joined should not affect performance in good tuned database.
OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 99-101
Chapter 3: SQL Application Tuning and Design
No comments:
Post a Comment