Re: Calculations in maximizing rows per block
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 15 Aug 2017 10:06:20 -0400
Message-ID: <8da3c8c5-8ae9-d6ed-1f96-f252fd78c094_at_gmail.com>
Date: Tue, 15 Aug 2017 10:06:20 -0400
Message-ID: <8da3c8c5-8ae9-d6ed-1f96-f252fd78c094_at_gmail.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 15 2017 - 16:06:20 CEST