Re: Identifying free space in a block

avsp or fseo-fsbo is the free space in the block.

Cheers

Riyaj Shamsudeen
Principal DBA,
Ora!nternals - http://www.orainternals.com - Specialists in Performance, RAC and EBS
Blog: http://orainternals.wordpress.com/ Oracle ACE Director and OakTable member <http://www.oaktable.com/>

Co-author of the books: Expert Oracle Practices <http://tinyurl.com/book-expert-oracle-practices/>, Pro Oracle SQL, <http://tinyurl.com/ahpvms8> <http://tinyurl.com/ahpvms8>Expert RAC Practices 12c. <http://tinyurl.com/expert-rac-12c> Expert PL/SQL practices <http://tinyurl.com/book-expert-plsql-practices>

<http://tinyurl.com/book-expert-plsql-practices>

On Tue, Jan 24, 2017 at 3:13 AM, Paul Houghton <Paul.Houghton_at_uis.cam.ac.uk> wrote:

> Hi
>
> How do I identify how much free space is in a specific block? I know that
> the ITL can grow if there is space in the block. I have dumped the block
> and can see there are 5 entries, so how can I tell if a 6th entry could be
> created?
>
> I don't believe it needs to grow, I am just curious.
>
> Oracle 12.1.0.2 Linux x86_64
>
> Thanks
>
> Paul Houghton
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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