URGENT - ratios problems

[farrokhp]

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

[jrpm]

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).

[sjadhavdba]

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.