Re: dba_extents vs dba_segments
- From: Jared Still <jkstill@xxxxxxxxx>
- To: genegurevich@xxxxxxxxxxxx
- Date: Thu, 12 Mar 2009 14:58:17 -0700
On Thu, Mar 12, 2009 at 12:45 PM, <genegurevich@xxxxxxxxxxxx> 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
Other related posts:
