Re: dba_extents vs dba_segments
Date: Thu, 12 Mar 2009 15:06:44 -0700 (PDT)
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".
- On Thu, 3/12/09, Jared Still <jkstill_at_gmail.com> wrote: From: Jared Still <jkstill_at_gmail.com> Subject: Re: dba_extents vs dba_segments To: genegurevich_at_discover.com Cc: asif_oracle_at_yahoo.com, oracle-l_at_freelists.org Date: Thursday, March 12, 2009, 2:58 PM
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 - 17:06:44 CDT