URGENT - ratios problems
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: URGENT - ratios problems

  1. #1
    Join Date
    Nov 2000
    Posts
    416
    Our PROD DB has the following bad ratios : Please advice for each what is the best I have to do.

    REDO ALLOCATION RETRIES RATIO - should be < 1%
    ----------------------------- ------------------
    20.1101

    FREE_MEMORY/SHARED_POOL RATIO - should be < 1%
    ----------------------------- ------------------
    8.7378

    FREE_MEMORY/SP_RES RATIO - should be < 10%
    ------------------------ ------------------
    100.0000

    LATCH W2W MISS RATIO LATCH IMMED MISS RATIO - should be < 1%
    -------------------- ---------------------- ------------------
    47.4651 .6487


    FILE SYSTEM SIZE RATIO PHYSYCAL READS RATIO PHYSYCAL WRITES RATIO - should be > 50%
    ---------------------- -------------------- --------------------- ------------------
    100.0000 100.0000 100.0000

    FILE SYSTEM NAME SIZE (MB) PHYSYCAL READS PHYSYCAL WRITES
    -------------------------------------------------- ---------------- ---------------- ---------------
    19,860 853,117 12,848,447
    An ounce of prevention is worth a pound of cure

  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    You did not say what release, but basically, I guess you need more db block buffers and a larger shared pool.

    As to how much more to add, that depends on your server and your application(s).
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  3. #3
    Join Date
    Dec 2001
    Posts
    221
    you should provide some more details beyond this report. i.e. which version of oracle, whether its a production database, if not whether you've taken this ratios immediatly after starting the database.

    remember, you'll not get the proper ratio unless and until you've worked for a long time after starting the database. if you could give more details then there are many talents who can provide u ur answers.
    Santosh Jadhav
    8i OCP DBA

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