sever2012 网站建设,做个普通网站多少钱,花店网站开发参考文献,专利交易网站建设ppt登录sqlplus#xff1a;cmd命令行登录#xff1a;sqlplus orcl/orcl as sysdba查询表空间使用率select b.file_id 文件ID,b.tablespace_name 表空间,b.file_name 物理文件名,b.bytes 总字节数,(b.bytes-sum(nvl(a.bytes,0))) 已使用,sum(nv…登录sqlpluscmd命令行登录sqlplus orcl/orcl as sysdba查询表空间使用率select b.file_id 文件ID,b.tablespace_name 表空间,b.file_name 物理文件名,b.bytes 总字节数,(b.bytes-sum(nvl(a.bytes,0))) 已使用,sum(nvl(a.bytes,0)) 剩余,sum(nvl(a.bytes,0))/(b.bytes)*100 剩余百分比from dba_free_space a,dba_data_files bwhere a.file_idb.file_idgroup by b.tablespace_name,b.file_name,b.file_id,b.bytesorder by b.tablespace_nameselect tablespace_name, segment_name, bytes / 1024 / 1024 from user_segments where segment_type ‘TABLE‘ and tablespace_name ‘VNOX‘ order by bytes desc ;1, dba_data_files,dba_segments,dba_free_space得出结论:一般情况下(没有drop表的时候):dba_data_files bytes (dba_segments bytes dba_free_space bytes)实验:SQL Select sum(bytes)/1024/1024/1024 from dba_segments;SUM(BYTES)/1024/1024/1024-------------------------1.58441162SQL select sum(bytes)/1024/1024/1024 from dba_free_space;SUM(BYTES)/1024/1024/1024-------------------------.323669434SQL select sum(bytes)/1024/1024/1024 from dba_data_files;SUM(BYTES)/1024/1024/1024-------------------------1.9140625原文https://www.cnblogs.com/nieyuqin/p/10622676.html
