Identifying free space in a block

From: Paul Houghton <Paul.Houghton_at_uis.cam.ac.uk>
Date: Tue, 24 Jan 2017 11:13:44 +0000
Message-ID: <HE1PR0701MB2634616563CDC2F4535C9445E6750_at_HE1PR0701MB2634.eurprd07.prod.outlook.com>

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

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

Received on Tue Jan 24 2017 - 12:13:44 CET

This message: [ Message body ]
Next message: Mark W. Farnham: "RE: Identifying free space in a block"
Previous message: H. Abhishek: "Exadata cell disk erase - disk scrubbing"
Next in thread: Mark W. Farnham: "RE: Identifying free space in a block"
Reply: Mark W. Farnham: "RE: Identifying free space in a block"
Reply: Stefan Koehler: "Re: Identifying free space in a block"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message