Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: latch contention
Bear in mind that a development system
may be the same size as a production
system, but it is unlikely to receive the
same degree of concurrent usage, and
it is concurrency that causes latch contention
(or viewing it from another angle, latches
allow for maximum concurrency)
The TCH is incremented at most once
every 3 seconds, so you have two buffers
which have extraordinarily high touch counts
under this latch, plus a couple of others
with fairly high counts.
I would look at
object 23593
object 23606
What do they represent, and what is in
their blocks (8, 1124) and (10, 1824)
respectively.
At this point, you have to try to associate these anomalous figures with your knowledge of how the application is supposed to work, and the style of the code used.
-- Jonathan Lewis Host to The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases See http://www.jlcomp.demon.co.uk/book_rev.html Seminars on getting the best out of Oracle See http://www.jlcomp.demon.co.uk/seminar.htmlReceived on Wed Jun 27 2001 - 08:20:28 CDT