Re: dba_extents vs dba_segments

From: Asif Momen <asif_oracle_at_yahoo.com>
Date: Thu, 12 Mar 2009 15:06:44 -0700 (PDT)
Message-ID: <777315.98397.qm_at_web56607.mail.re3.yahoo.com>



Hi,

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".

Regards

Asif Momen
http://momendba.blogspot.com

  • 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$%';

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 - 17:06:44 CDT

Original text of this message