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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Paul Houghton
Sent: Tuesday, January 24, 2017 6:14 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
