buffer cache hit ratios

[ligang]

Some concern

1. U can not test the system just after mounting the database , at that time , everything in SGA is empty , the hit radio is very low .
(that's why I ask you to give me the report at 5 PM)
2. Increase too much , Double DB_BLOCK_BUFFER is dangerous as it may cause system memory swap . Tuning memory should be
done step by step
3. I don't understand why he increase share pool . No meaning , I guess his DB is not so big ( as the SGA is small ) So the library cache and dictionary cache should be enough to use . Even I feel it's too much . Maybe Share pool should be decrease to less than 30 MB

[TimHall]

Nonsense. You just go home and come back a day or two later. By the time you get back people are desperate and love you when you cure everything by bouncing the instance

[julian]

Originally posted by TimHall
Nonsense. You just go home and come back a day or two later. By the time you get back people are desperate and love you when you cure everything by bouncing the instance

:-)) Sometimes the easiest remedy could be just bouncing the base.