Re: An OCP Exam question: V$RECENT_BUCKET?

The correct answer is A and C. There are two views v$current_bucket and v$recent_bucket used for determining how adding or removing db buffers will impact performance respectively. The V$ views reference their respective x$ tables. These views do exist in oracle 8.0.x

ps - I got a 99% in this test :-) and should have my OCP by next Tuesday. Good luck to you......

>
> 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?
> >
> >
> >
> >
>
>

--
Doug Coan
Senior Client Server System Integrator
AEGON USA
dcoan_at_aegonusa.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 13:56:08 CST