Re: database statistics histograms ...

From: <fitzjarrell_at_cox.net>
Date: Fri, 15 Jun 2007 11:57:01 -0700
Message-ID: <1181933821.214023.206940@k79g2000hse.googlegroups.com>

On Jun 15, 1:21 pm, zigzag..._at_yahoo.com wrote:
> I am using 9.2.0.6 on Windows Server 2000.
>
> I have a packaged application, which did not use bind variables.
> Database statistics collection included computing histograms of 250
> buckets on some columns.
>
> Now we use cursor_sharing=force which converts literals to bind
> variables.
>
> Will histograms be ever used? If not, I can delete them.
>
> I know Oracle still does bind peeking so not sure whether histograms
> will still be used....

The vendor needs to correctly write software; this 'fix' you've implemented doesn't solve the problem, it merely masks some of the symptoms.

The cursor must come from somewhere so you do have situations where there is no existing cursor to 'match'. I wouldn't be dumping your histograms any time soon.

David Fitzjarrell Received on Fri Jun 15 2007 - 13:57:01 CDT