Re: database statistics histograms ...

On Fri, 15 Jun 2007 11:21:33 -0700, zigzagdna_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....

Histograms will be used for the first of ocurrence of a statement. Further invocations will not use histograms. This is why on some occasions you may want to use hardcoded literals. In your case hardcoded literals are gone, and this may pose problems. Setting cursor_share to force is a KLUDGE.

-- 
Sybrand Bakker
Senior Oracle DBA