Oracle查询: dba_segments + dba_objects

Question

我希望修改这个sql以从dba_objects中添加max(已创建)和max(Dba_objects)。我该怎么做？谢谢。

select owner, segment_name, sum(bytes) sb 
from dba_segments 
where tablespace_name = 'USERS' 
group by owner, segment_name order by sb desc

Answer 1

如下所示：

select ds.owner,ds.segment_name,sum(ds.bytes) sb, 
max(do.created) mc, max(do.last_ddl_time) md
from dba_segments ds join dba_objects do 
  on (ds.owner=do.owner and ds.segment_name=do.object_name)
where tablespace_name = 'USERS'
group by ds.owner, ds.segment_name
order by sb desc;

如果这是另一回事:-)