Oracle 10g = bloatware?
From: Matthias Hoys <matthias.hoys_at_gmail.com>
Date: Wed, 11 Apr 2012 07:37:49 -0700 (PDT)
Message-ID: <31272374.311.1334155069119.JavaMail.geo-discussion-forums_at_yndc3>
This is on 10g:
select sum(bytes)/1024/1024 MB from dba_extents where owner = 'FLOWS_FILES'; MB
945.75
Date: Wed, 11 Apr 2012 07:37:49 -0700 (PDT)
Message-ID: <31272374.311.1334155069119.JavaMail.geo-discussion-forums_at_yndc3>
This is on 10g:
select sum(bytes)/1024/1024 MB from dba_extents where owner = 'FLOWS_FILES'; MB
945.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
211.75
??? The number of rows are the same, tablespace properties too...
Matthias Hoys Received on Wed Apr 11 2012 - 09:37:49 CDT