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.html