Latch Free event in library Cache
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.
regards
anandkl