Oracle 10g = bloatware?
From: Matthias Hoys <matthias.hoys_at_gmail.com>
Date: Wed, 11 Apr 2012 07:35:56 -0700 (PDT)
Message-ID: <30414700.473.1334154956424.JavaMail.geo-discussion-forums_at_yngq4>
This is on 10g:
select sum(bytes)/1024/1024 MB from dba_extents where owner = 'FLOWS_FILES'; MB
211.75
Date: Wed, 11 Apr 2012 07:35:56 -0700 (PDT)
Message-ID: <30414700.473.1334154956424.JavaMail.geo-discussion-forums_at_yngq4>
This is on 10g:
select sum(bytes)/1024/1024 MB from dba_extents where owner = 'FLOWS_FILES'; MB
211.75
This is on 11gR2, after export/import using Data Pump:
select sum(bytes)/1024/1024 MB from dba_extents where owner = 'FLOWS_FILES';
MB
945.75
??? The number of rows are the same, tablespace properties too...
Matthias Hoys Received on Wed Apr 11 2012 - 09:35:56 CDT