Hi All,
oracle version=8.1.6
os=sun 2.7
database =production

I have very serious problem with my production database.Daily every morning there is a huge wait for Latch free wait event in library cache and the database cannot take this wait and goes down.

I know if i increase the size of the shared_pool i would benifit,but this is temporary solution.And also i have set the latch no. to the max. allowed.

Can you please suggest me a permanenet solution for this problem.