察看数据库的大小，和空间使用情况

--察看数据库的大小，和空间使用情况
SELECT upper(f.tablespace_name) 表空间名,       d.Tot_grootte_Mb "表空间大小(M)",       d.Tot_grootte_Mb - f.total_bytes "已使用空间(M)",       round((d.Tot_grootte_Mb - f.total_bytes) / d.Tot_grootte_Mb * 100,2) "使用比",       f.total_bytes "空闲空间(M)",       f.max_bytes "最大块(M)" FROM          (SELECT tablespace_name,            round(SUM(bytes)/(1024*1024),2) total_bytes,            round(MAX(bytes)/(1024*1024),2) max_bytes      FROM sys.dba_free_space     GROUP BY tablespace_name) f,    (SELECT dd.tablespace_name, round(SUM(dd.bytes)/(1024*1024),2) Tot_grootte_Mb      FROM   sys.dba_data_files dd      GROUP BY dd.tablespace_name) dWHERE d.tablespace_name = f.tablespace_name    ORDER BY 4 DESC

 

 

=====================

select t.segment_name, t.tablespace_name, t.bytes / 1024 / 1024 / 1024  from dba_segments t where t.owner = 'ZSQYZC'   AND T.segment_type = 'TABLE' order by t.bytes desc

 

=====================

create table jyfx_jzkh_day100 as select * from qyzc.jyfx_jzkh_day@jhqyzc where rownum<100