Performance Tuning question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Performance Tuning question

  1. #1
    Join Date
    Jan 2001
    Posts
    2,828
    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


  2. #2
    Join Date
    Sep 2001
    Location
    Australia
    Posts
    18
    The answer is (a) and (c).
    You specify the number of buffers you want to add and query v$recent_bucket.

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hi anthony

    Thanks for the reply...

    regards
    Hrishy

  4. #4
    Join Date
    Sep 2001
    Location
    Australia
    Posts
    18
    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!

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    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
  •  



Click Here to Expand Forum to Full Width