Re: dba_extents vs dba_segments

From: Asif Momen <>
Date: Thu, 12 Mar 2009 15:06:44 -0700 (PDT)
Message-ID: <>


Yes, the recyclebin created a nuisance with me as well. Developers use to report that they see garbage table names starting with "BIN", when they issue "select * from tab".


Asif Momen

  • On Thu, 3/12/09, Jared Still <> wrote: From: Jared Still <> Subject: Re: dba_extents vs dba_segments To: Cc:, Date: Thursday, March 12, 2009, 2:58 PM

On Thu, Mar 12, 2009 at 12:45 PM, <> wrote:

Looks like this is an answer.

Now I exclude the recyclebin objects

SQL> select sum(bytes/1024)/1024 from dba_segments where tablespace_name =

'PCM_D_01' and segment_name not like 'BIN$%';



This is quite interesting, I wasn't previously aware of this issue with recyclebin.

This might be playing havoc with my script for determining space in the database, guess it would be a good idea

check which is being used - dba_extents or dba_segments.


Received on Thu Mar 12 2009 - 17:06:44 CDT

Original text of this message