Re: Library Cache and Share wait on Latch - Version Count Huge
From: Tanel Poder <tanel_at_poderc.com>
Date: Thu, 18 Mar 2010 08:46:31 +0800
Message-ID: <4602f23c1003171746hc445434l74ddfe8cfd9e582_at_mail.gmail.com>
Of course before you do anything, check whether the tables involved in the problem queries do have histograms in their stats at all, to make sure that this is your problem.
Date: Thu, 18 Mar 2010 08:46:31 +0800
Message-ID: <4602f23c1003171746hc445434l74ddfe8cfd9e582_at_mail.gmail.com>
Of course before you do anything, check whether the tables involved in the problem queries do have histograms in their stats at all, to make sure that this is your problem.
Also, check whether any of the V$SQL_SHARED_CURSOR columns is Y, like I've done in the end of this blog article:
http://blog.tanelpoder.com/2009/01/23/multipart-cursor-subexecution-and-precompute_subquery-hint/
-- Tanel Poder http://tech.e2sn.com On Thu, Mar 18, 2010 at 8:43 AM, Tanel Poder <tanel_at_poderc.com> wrote:Received on Wed Mar 17 2010 - 19:46:31 CDT
> After setting method_opt to REPEAT you will also need to manually drop all
> the histograms, as they have been already created for you.
>
>
>
-- http://www.freelists.org/webpage/oracle-l