Re: Calculations in maximizing rows per block

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 15 Aug 2017 10:06:20 -0400

Have you tried ANALYZE TABLE LIST CHAINED ROWS INTO ....?


On 08/15/2017 09:19 AM, Rich J wrote:


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


--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217

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


Other related posts:

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