select owner,sum(a.num_rows) as TOTAL_ROWS from dba_tables  a
where owner in ('PORTAL_PROJ','DATASYNC_PROJ') group by owner;

查询指定用户下的数据所占的空间大小，单位MB

select owner,sum(a.bytes)/1024/1024 as SizeMB from dba_segments  a
where owner in ('PORTAL_PROJ','DATASYNC_PROJ') group by owner;

------------正 文 已 结 束， 感 谢 您 的 阅 读 （折雨的天空）--------------------

转载请注明本文标题和链接：《oracle统计数据库总记录条数及所占存储容量》