RE: Who is using my datafile

From: Mercadante, Thomas F (LABOR) <>
Date: Wed, 9 Jul 2008 08:55:52 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE090A5@EXCNYSM0A1AJ.nysemail.nyenet>


Find a table in your database that is using multiple extents/segments and query these two views and you will figure it out. They are very usefull in determining how Oracle has stored your object.


-----Original Message-----
[] On Behalf Of Yechiel Adar Sent: Wednesday, July 09, 2008 2:27 AM
Subject: Re: Who is using my datafile

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.
> 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.


Received on Wed Jul 09 2008 - 07:55:52 CDT

Original text of this message