The DBMS_STATS.GATHER_SYSTEM_STATS routine collects system statistics in a user-defined time frame.
Which four statements are true of the GATHER_SYSTEM_STATS routine? (Choose four.)
A. You can use the GATHERING_MODE => 'END' option to end system statistics collection.
B. You can use the INTERVAL option to specify a fixed interval to collect statistics.
C. You can use the GATHERING_MODE => 'START' option to enable manual statistics collection.
D. The routine allows the optimizer to consider a system's CPU and I/O utilization and performance.
E. The routine allows the optimizer to invalidate existing cached plans.
Answer: A, B, C, D
Explanation:
You can use the GATHERING_MODE => 'END' option to end system statistics collection, the GATHERING_MODE => 'START' option to enable manual statistics collection. The INTERVAL option is used to specify a fixed interval to collect statistics. The routine allows the optimizer to consider a system's CPU and I/O utilization and performance.
Incorrect Answers
E: The routine does not allow the optimizer to invalidate existing cached plans.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 220-222
Chapter 4: Performance and Scalability Enhancements
Oracle 9i New Features, Robert Freeman, p. 180-185
Chapter 6: Oracle9i SQL, PL/SQL New Features
No comments:
Post a Comment