Re: dba_extents vs dba_segments

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 12 Mar 2009 14:58:17 -0700
Message-ID: <bf46380903121458l1d590dc2veca311bd1528c9ec_at_mail.gmail.com>

 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$%';
>
> SUM(BYTES/1024)/1024
> --------------------
> 536900
>

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.

Jared

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 12 2009 - 16:58:17 CDT