You want to find the high water mark and the number of blocks above the high water mark without analyzing the table. Which method will provide this information?
A. Use DBMS_OUTPUT package.
B. Use the ANALYZE command.
C. Use DBMS_SQL.PARSE procedure.
D. Use DBMS_SPACE.UNUSED_SPACE procedure.
Answer: D
Explanation:
The DBMS_SPACE.UNUSED_SPACE procedure will help you to find the high water mark and the number of blocks above the high water mark without analyzing the table. This procedure returns information about unused space in an object (table, index, or cluster).
Incorrect Answers
A: Package DBMS_OUTPUT enables you to display output from PL/SQL blocks and subprograms, which makes it easier to test and debug them.
B: The task is not to use the ANALYZE command.
C: The PARSE procedure from the DBMS_SQL package can be used to parse DML or DDL statement.
OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 40-41
Chapter 2: Sources of Tuning Information
No comments:
Post a Comment