Hi Guys

I am working on Windows NT 4.0 & Oracle 7.3.4 Database.My Database performance is NOT THAT GOOD.

The Physical RAM on server is 780 MB

SGA size is 120000000

db_block_buffers 20000

The Statistics are below.See there The Db buffer hit ratio is very very poor & Also Hit ratio of Row cache is not
that much good.It's a 24*7 Database.Can you give me any Valuable Suggestions and Advices to Improve the Performance of My Database.I increased the db_block_buffers from 18000 To 20000.Even though there is no much Improvement.I ran the utlbstat and utlestat at different time intervals and collected the statistics.


1.SQL> select name,value from v$sysstat where name in('db block gets','consistent gets','physical reads');

NAME VALUE
---------------------------------------------------------------- ----------
db block gets 742893
consistent gets 33363298
physical reads 27658686

1-[Physical reads/(db block gets + consistent gets)] = .81095


2.SQL> select * from v$sgastat where name='free memory';

NAME BYTES
-------------------------- ----------
free memory 21716996


3.SQL> select (sum(pins-reloads))/sum(pins) "Lib Cache" from v$librarycache;

Lib Cache
----------
.99995384


4.SQL> select (sum(gets - getmisses - usage - fixed)) / sum(gets) "Row Cache" from v$rowcache;

Row Cache
----------
.967373848

Thanks in Advance
Ravi