An OCP Exam question: V$RECENT_BUCKET?

Hi,

I took the third OCP Exam yesterday.
I think the following question is debatable:

Question: If you suspect the size of buffer cache may be not large enough, what two things can you do to identify the affect if you enlarge the buffer cache? (Choose two)

A. Set the parameter DB_BLOCK_LRU_EXTENDED_STATISTICS to a positive integer.
B. Set the parameter DB_BLOCK_LRU_STATISTICS to TRUE.
C. Query the V$RECENT_BUCKET view.
D. Query the V$FILESTAT view.

Since the question claims two selections, I had chosen (A) and (C). But, the correct answer is (A) and to query the x$kcbrbh fixed table. The DB_BLOCK_LRU_EXTENDED_STATISTICS, DB_BLOCK_LRU_STATISTICS paramenters and the x$kcbrbh fixed table are obsoleted in Oracle 8.1.3.

IMO, there is a fault in the selection (C). In Oracle 7 and 8, there is no such a view called V$RECENT_BUCKET. Is V$RECENT_BUCKET a remnant in the old version of Oracle? Received on Tue Nov 23 1999 - 09:14:35 CST