Free space in segments

From: Ralf Jonas <ralf.jonas_at_gmx.de>
Date: Fri, 18 Jan 2002 09:22:55 +0100
Message-ID: <a28m2s$v4hnf$1@ID-6634.news.dfncis.de>

Does anyone know how to get the information how much space is left in a segment? I have a segment 50 GB in size. The extents are 20 MB each. This segment holds LOB-Data for our application. Of course I can calculate the amount of all the LOB-data with

select sum(dbms_lob.getlength(data_field)) from xxx

but this takes far too long for our needs. Seems I have to sum up the free space in each extent, but how?

Thanks in advance
Ralf Jonas Received on Fri Jan 18 2002 - 02:22:55 CST