Which script creates views that will tell you who is holding or waiting for which tables?
A. CATPROC.sql
B. CATLOCK.sql
C. CATPERF.sql
D. CATBLOCK.sql
E. CATBPROC.sql
Answer: D
Explanation:
A CATBLOCK.sql script creates the lock views that UTLOCKT.sql script needs, so you must run it before running UTLOCKT.sql.
Incorrect Answers
A: CATPROC.sql script is required to load the initial PL/SQL environment.
B: There is no CATLOCK.sql script in Oracle9i.
C: There is no CATPERF.sql script in Oracle9i.
E: There is no CATBPROC.sql script in Oracle9i.
OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 468-470
Chapter 9: Tuning Contention
No comments:
Post a Comment