db reorg?
From: C P <carlospena999_at_gmail.com>
Date: Wed, 23 May 2012 15:37:06 -0500
Message-ID: <CAPTPB12UtieYbG0jp1O60LS=23rYqierOGzr5ZfCeHyZOdvs7g_at_mail.gmail.com>
Hi
we have a 10.2 database that is like this:
259525.374
422298.839
Date: Wed, 23 May 2012 15:37:06 -0500
Message-ID: <CAPTPB12UtieYbG0jp1O60LS=23rYqierOGzr5ZfCeHyZOdvs7g_at_mail.gmail.com>
Hi
we have a 10.2 database that is like this:
select sum(bytes)/1024/1024 from dba_segments;
SUM(BYTES)/1024/1024
259525.374
SQL> select sum(bytes)/1024/1024 from dba_data_files;
SUM(BYTES)/1024/1024
422298.839
Does this mean we can look for objects to perform re org?
CP.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 23 2012 - 15:37:06 CDT