Performance Tuning question

Hi All

Users are reporting slow response time on your system. You think that the problem can be solved by increasing the size database buffer cache. But you want to make sure your solution is correct. Which two steps are necessary to evaluate the impact of adding buffers to database buffer cache?

a. Set the parameter DB_BLOCK_LRU_EXPANDED_STATISTICS to the number of buffers you want to add.
b. Set the parameter DB_BLOCK_LRU_EXPANDED_STATISTICS=True.
c. Query the V$RECENT_BUCKET view.
d. Query V$FILESTAT.


answer is b and c am i right ?

regards
Hrishy

The answer is (a) and (c).
You specify the number of buffers you want to add and query v$recent_bucket.

Hi anthony

Thanks for the reply...

regards
Hrishy

Did you know that the v$recent_bucket view is obsolete in Oracle 8.1 and higher?

I just read it here : http://gwynne.cs.ualberta.ca/~oracle...2/migcntfl.htm

If the link doesn't work search for "v$recent_bucket oracle 8.1.7" on google".

So if you are studying for your 8i performance tuning exam I doubt that this question will come up!

Hi anthony

Yep i am preparing for Oracle8i...thanks for the excellent piece of info.

regards
Hrishy