RE: Identifying free space in a block

Let's see. hmm. You could add up the vsize() of each not null column in the table that occupies that block and see if it is even plausible pretending itls have not been expanded. So block_size - minimum header size - sum(vsize(col1)+vsize(col2)+...+(vsize(coln))) where rowid in that block.

Then you could look at the block dump and get up one of the block decoder pages to see if you can calculate expansion of ilts.

This is just academic right? (You can't actually test shoving another row in there unless it is next up on the free list.)

mwf

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paul Houghton
Sent: Tuesday, January 24, 2017 6:14 AM
To: oracle-l_at_freelists.org
Subject: Identifying free space in a block

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 Received on Tue Jan 24 2017 - 16:07:00 CET