Re: dbms_stats.gen_selmap

Lothar,
Did you try to trace the dbms_stats activities? Jared Still has documented some trace levels here: https://blog.pythian.com/options-for-tracing-oracle-dbms_stats/

hth
 Martin

2017-12-15 15:14 GMT+01:00 Franck Pachot <franck_at_pachot.net>:

> Hi Lothar,
> It seems related to online statistics gathering, which makes sense during
> an insert append.
> Regards,
> Franck.
>
> On Fri, Dec 15, 2017 at 1:40 PM Lothar Flatz <l.flatz_at_bluewin.ch> wrote:
>
>> We could trace it back to an insert /*+ append */. I did a little
>> experiment. The call is actually related to dynamic statistics generation.
>>
>>
>> Am 15.12.2017 um 09:41 schrieb Lothar Flatz:
>> > Hi,
>> >
>> > this is a long running procedure on one of our DB's. According to
>> > Morgans Library it is an undocumented subprogram. Does anybody know
>> > what it does and when it is called?
>> >
>> > Regards
>> >
>> > Lothar
>> >
>>
>> --
>>
>>
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>

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