Re: Searching MOS Note on dynamic sampling
Date: Sat, 29 Feb 2020 20:12:08 -0500
Message-ID: <f8b50bd0-524e-b531-ed9e-b7a21965a051_at_gmail.com>
Hi Lothar!
This is not a MOS note but Nigel Baylis's blog:
https://blogs.oracle.com/optimizer/dynamic-sampling-and-its-impact-on-the-optimizer
There is also an old Oracle Magazine Article by The Oracle Master (Tom for short) Kyte:
https://blogs.oracle.com/oraclemagazine/on-dynamic-sampling
This is one of the very few articles by Tom Kyte that have survived his retirement.
Regards
On 2/28/20 3:22 AM, Lothar Flatz wrote:
> Hi Guys,
>
> I colleague of mine told me that he read a MOS Note that was
> describing the details of the way dynamic sampling is done.
> The note was mentioning that only bitmap blocksĀ are sampled and
> blocks less than 25% full are considered empty.
> In that same note also deferred segment creation is mentioned.
> As my colleague is very experienced I believe is memory is correct.
> However, we cannot find that note any more.
>
>
> Can somebody point us to the doc?
>
> Regards and thank
>
> Lothar
>
>
> --
>
>
>
>
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Sun Mar 01 2020 - 02:12:08 CET