Oracle Database Object growth record query comparison statement

Oracle Database Object growth record query comparison statement: select * from (selecta. owner, a. segment_name, a. tablespace_name, B. megas-a.megasd

Oracle Database Object growth record query comparison statement: select * from (select a. owner, a. segment_name, a. tablespace_name, B. megas-a.megas d

Comparison Statement of Oracle Database Object growth record query:

Select * from (
Select a. owner, a. segment_name, a. tablespace_name, B. megas-a.megas diff
From
(Select owner, segment_name, tablespace_name, sum (megas) megas
From object_rd
Where to_char (recode_time, 'yyyymmdd') = '20140901'
Group by owner, segment_name, tablespace_name),
(Select owner, segment_name, tablespace_name, sum (megas) megas
From object_rd
Where to_char (recode_time, 'yyyymmdd') = '20140901'
Group by owner, segment_name, tablespace_name) B
Where a. owner = B. owner
And a. segment_name = B. segment_name
-- And a. segment_type = B. segment_type
And a. tablespace_name = B. tablespace_name) c
Where c. diff> 1
Order by c. diff desc

,