Re: Who is using my datafile
- From: Yechiel Adar <adar666@xxxxxxxxxxxx>
- Date: Wed, 09 Jul 2008 09:27:15 +0300
I am a little confused here.
I thought that dba_segments contain information about space allocated to
objects and dba_extents contain the information about the space
allocation within each segments.
Now I find that:
select * from dba_segments where header_file = 7;
return no rows while:
select * from dba_extents where file_id = 7;
return some rows.
So, I am switching to check dba_extents to clear space in datafiles.
What is the purpose of dba_segments?
Adar Yechiel
Rechovot, Israel
Yechiel Adar wrote:
I have a RAC on windows.
Oracle 9206.
OCFS.
I have five datafiles that have nothing in them.
I mean that select * from sys.seg$ where file# between 6 and 11 return
nothing.
When I tried to decrease the size of the datafiles I got: the file
contain data beyond the space I want to decrease to.
I thought that maybe there are some temporary segments but all the
users use temp as their temporary tablespace.
TIA
--
//www.freelists.org/webpage/oracle-l
Other related posts:
