Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!k70g2000cwa.googlegroups.com!not-for-mail From: "Dusan Bolek" Newsgroups: comp.databases.oracle.server Subject: Connection between library cache latches and statistics? Date: 10 Oct 2006 06:08:06 -0700 Organization: http://groups.google.com Lines: 13 Message-ID: <1160485686.081819.59340@k70g2000cwa.googlegroups.com> NNTP-Posting-Host: 194.228.113.140 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1160485691 29364 127.0.0.1 (10 Oct 2006 13:08:11 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 10 Oct 2006 13:08:11 +0000 (UTC) User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe) X-HTTP-Via: ICAP/1.0 10.7.11.26 Complaints-To: groups-abuse@google.com Injection-Info: k70g2000cwa.googlegroups.com; posting-host=194.228.113.140; posting-account=fAia6g0AAAADdyRCneOVrn-0gkeCBzJM Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276915 I'm encountering a strange problem. We're suffering from terrible library cache latches (30-50% of waits in statspack reports) when table's stats being older than two business days. I do not understand why, because the affected tables are only slowly changing and I can't imagine any possible connection between stats too old and library latch waits. Any ideas? Database: 9.2.0.7 EE 64bit Itanium -- Dusan Bolek