I had the same question last week, and I answered A and B but I don't know
whether I was right or wrong. I knew this is the two steps you require to be
able to evaluate the Buffer cache increase. And besides the other two
options were definitley wrong from my point of view.
By the way did you Pass? I hope so.
regards
reza
fumi <fumi_at_tpts5.seed.net.tw> wrote in message
news:81eb0r$61u$1_at_news.seed.net.tw...
> 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:40:56 CST
