Re: Calculations in maximizing rows per block

  • From: Rich J <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 15 Aug 2017 08:19:15 -0500

On 2017/08/14 16:07, Mladen Gogala wrote:

Of course, it is always good to read the classics: 

https://jonathanlewis.wordpress.com/2010/06/08/continued-rows/ ;

https://jonathanlewis.wordpress.com/2017/05/19/255-columns-2/ ;

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1830023856761
 

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1606678460320

Well, almost.  Only the second article deals specifically with
intra-block chaining due to high column count.  Lots of great insight as
always by Jonathan, but I'm still short on the specifics of calculating
the free space in a data block (intra-block chaining or not) in an 11.2+
database. 

Thanks,
Rich

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2017