Re: Re: Searching MOS Note on dynamic sampling

From: <>
Date: Tue, 3 Mar 2020 14:20:13 +0100 (CET)
Message-ID: <>

Hi Mladen,
thanks, I know what dynamic sampling is. I had deep level questions on how it works internally. You will find the questions below.
Thanks and Reagrds
----Urspr√ľngliche Nachricht----

Von :
Datum : 01/03/2020 - 02:12 (MN)
An :
Betreff : Re: Searching MOS Note on dynamic sampling Hi Lothar!
This is not a MOS note but Nigel Baylis's blog: There is also an old Oracle Magazine Article by The Oracle Master (Tom for short) Kyte: 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    



Mladen Gogala
Database Consultant
Tel: (347) 321-1217

-- Received on Tue Mar 03 2020 - 14:20:13 CET

Original text of this message