-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|