Re: log file sync + latch free WAITs

log file sync wait is part of Oracle life, like your heart beating

latch free waits aren't obligatory but are usually extremely fast so often are not a problem. If you really think they are a problem you need to look at v$latch and see which latch.

Why are you looking at these waits? THere are other waits that seem more interesting in your out put like enqueues, free buffer, free buffer, log file switch completion ...

What is interesting is to see how long you are waiting for waits and not just how many times you waited. Why don't you select TIME_WAITED in your select? You need timed statistics set ( in 99% of the cases this has negligible impact on the perf, and the 1% that I know of are bugs).

Best
Kyle

PS Some info that might be useful to you is on http://www.geocities.com/oraperf/seminar.html

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 30 2001 - 19:25:27 CST