Re: dba_extents vs dba_segments
- From: Asif Momen <asif_oracle@xxxxxxxxx>
- To: genegurevich@xxxxxxxxxxxx, Jared Still <jkstill@xxxxxxxxx>
- Date: Thu, 12 Mar 2009 15:06:44 -0700 (PDT)
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@xxxxxxxxx> wrote:
From: Jared Still <jkstill@xxxxxxxxx>
Subject: Re: dba_extents vs dba_segments
To: genegurevich@xxxxxxxxxxxx
Cc: asif_oracle@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
Date: Thursday, March 12, 2009, 2:58 PM
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:
