一,查看数据库表空间大小
select tablespace_name ,sum(bytes) / 1024 / 1024 as MB from dba_data_files group by tablespace_name;
二,查看数据库中表的总数
select count(*) from user_tables;
三,数据条数
select sum(num_rows) from user_tables;
一,查看数据库表空间大小
select tablespace_name ,sum(bytes) / 1024 / 1024 as MB from dba_data_files group by tablespace_name;
二,查看数据库中表的总数
select count(*) from user_tables;
三,数据条数
select sum(num_rows) from user_tables;
转载于:https://my.oschina.net/zhangmaoyuan/blog/1855000