Re: dba_extents vs dba_segments
Date: Thu, 12 Mar 2009 14:58:17 -0700
On Thu, Mar 12, 2009 at 12:45 PM, <genegurevich_at_discover.com> 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.
JaredReceived on Thu Mar 12 2009 - 16:58:17 CDT