Re: Manually changing existing histograms

From: Carlos Sierra <carlos.sierra.usa_at_gmail.com>
Date: Tue, 14 May 2013 13:26:12 -0400
Message-Id: <715212C2-974C-4223-B789-774D72F5614C_at_gmail.com>

You can also use the undocumented module SQLT XGRAM which is located under sqlt/utl. Just download sqlt.zip from metal ink 215187.1. No need to install sqlt to use this XGRAM module. You can add a bucket to a frequency histogram with it. It allows you perform several other operations and it uses dbms_stats Apis

Cheers -- Carlos Sierra

On May 13, 2013, at 10:04 AM, breitliw_at_centrexcc.com wrote:

> Martin,
>
> I don't know about modifying an existing FB histogram. Just create the
> entire histogram from scratch, its is documented and there are examples
> on the net ( e.g. my own website ) on how to do it. Just use the number
> for the two values from the existing histogram and then add the 0 and
> the frequency you want to assign to it.
> Email me directly if you need specific help.
>
> On Mon, 13 May 2013 14:18:40 +0200, Martin Klier <usn_at_usn-it.de> wrote:
> Dear list,

>> 
>> how can I manually add a bucket to an existing Frequency Based histogram?

>
> --
> Wolfgang Breitling
> Centrex Consulting Corporation
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 14 2013 - 19:26:12 CEST