Hi,

I am receiving Alters from Oracle Enterprise Manager that the library cache miss ration is high, Current Ration: 4.1. My SGA is setup as follows:

shared_pool_size = 100 mg
shared_pool_reserved_size = 5 mg
large_pool_size = .5 mg
db_block_buffers = 3200
db_block_size = 16384
sort_area_size = 2 mg
sort_area_retain_size = 1 mg

My server has 4gig of memory, 2 processors and is running two instances that are setup identically.

Does anybody have any suggestions where I can look to fix this problem?

Thank you for your help.

Mike