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