Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Connection between library cache latches and statistics?

Connection between library cache latches and statistics?

From: Dusan Bolek <spambin_at_seznam.cz>
Date: 10 Oct 2006 06:08:06 -0700
Message-ID: <1160485686.081819.59340@k70g2000cwa.googlegroups.com>


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
Received on Tue Oct 10 2006 - 08:08:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US