Re: latch contention

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 27 Jun 2001 08:58:06 +0100
Message-ID: <993628501.10450.0.nnrp-13.9e984b29@news.demon.co.uk>

Which version of Oracle ?

How much contention ? Check v$system_event for the event 'latch free' to see how much time has been lost to latch contention since the database started up (assuming timed_statistics=true).

Also, show us the v$latch row for that latch.

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






Alexey Ogol wrote in message <9hc1k3$247n$1_at_pandora.alkar.net>...


>Hi,

>

>I run UTLBSTAT/UTLESTAT scripts, and I realize that there's a 'cache buffer

>chains' latch contention in the database. How can I eliminate this problem?

>

>Thanks in advance,

>Alexey

>

>

Received on Wed Jun 27 2001 - 02:58:06 CDT