Hi,
I'm trying to find the right way to query the amount of free space below the high water mark for a lob segment and any query I'm running doesn't give it to me. I can only see the amount of space that has been used at some point regardless of whether its free again now or not.
select sum(bytes)/1024/1024 SIZE_MB from user_extents where segment_name = 'LOB_SEGMENT_NAME';
I've also queried the dba_data_files, dba_tablespaces and dba_free_space for the tablespace level but still hitting the same issue.
Is is possible to query space that has previously been allocated to a segment/data file/tablespace that is now released to be reused?
Thanks,
O.