I saw a oracle doc. claim that:
Code: Select all
select s.owner, s.segment_name, s.segment_type,
from dba_segments s
where s.next_extent > (select MAX(f.bytes)
from dba_free_space f
where f.tablespace_name = s.tablespace_name);
We can get the segments that are unable to allocate their next extent
But, when i created a Tablespace and create some records to use up 100% of this tablespace with a table
until can't insert.
And I try to run the above sql. It get no return value.
And i found that, no any records related to my new created tablespace inside "dba_free_space".
The question i want to know is......
Is any tablespace will have record(s) inside dba_free_space to reflect the free extent?