ITPub博客

Oracle 查询各表空间使用情况--完善篇

原创 作者:maohaiqing0304 时间:2015-08-13 18:15:12 0 删除 编辑
<div style="orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;line-height:26px;font-family:Tahoma;text-align:-webkit-auto;background-color:#FFFFFF;"> <br /> <hr style="margin:0px;padding:0px;" /> </div> <div style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;text-align:-webkit-auto;background-color:#FFFFFF;"> <div> <div style="color:#666666;font-family:Tahoma;line-height:26px;"> <span style="font-size:10px;">链接:</span><a href="http://blog.itpub.net/28602568/viewspace-1770577/"><span style="font-size:10px;">http://blog.itpub.net/28602568/viewspace-1770577/</span></a> </div> <p style="color:#666666;font-family:Tahoma;margin-top:0px;margin-bottom:0px;border:0px;vertical-align:baseline;line-height:24px;"> <span style="font-size:10px;">标题:</span><span style="color:#565656;font-family:宋体, Arial;line-height:12px;font-size:10px;">&nbsp;</span><a href="http://blog.itpub.net/28602568/viewspace-1770577/" style="line-height:12px;text-decoration:none;color:#9C2423;font-family:微软雅黑, 黑体, Verdana;"><span style="font-size:10px;">Oracle 查询各表空间使用情况--完善篇</span></a> </p> <div style="color:#666666;font-family:Tahoma;line-height:26px;"> <span style="font-size:10px;">作者:</span><a href="http://blog.itpub.net/28602568/" shape="rect" style="text-decoration:none;color:#565656;"><span style="font-size:10px;">lōττéry</span></a><span style="font-size:10px;">&copy;版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]</span> </div> </div> <div style="color:#666666;font-family:Tahoma;line-height:26px;"> <hr style="margin:0px;padding:0px;" /> </div> </div> <br clear="none" style="line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;font-family:Tahoma;text-align:-webkit-auto;background-color:#FFFFFF;" /> <br style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;background-color:#FFFFFF;" /> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">前言</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;:</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;之前简单写过"</span><a href="http://blog.itpub.net/28602568/viewspace-1259396/"><span style="font-size:10px;">Oracle 查询各个 “表空间/数据文件” 的空间使用比情况</span></a><span style="font-family:'Courier New';font-size:10px;">"</span><span style="font-family:'Courier New';font-size:10px;">,</span><span style="font-family:'Courier New';font-size:10px;">当时只简单用到dba_data_file"总大小"与dba_free_space"剩余大小"来判断空间使用情况</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">;<br /> </span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">但当如下2种情况产生的时候</span><span style="font-size:10px;">&nbsp;,</span><span style="font-family:'Courier New';font-size:10px;">以前的脚本不太适用</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;;</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1</span><span style="font-family:'Courier New';font-size:10px;">、</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">DBF</span><span style="font-family:'Courier New';font-size:10px;">设置AUTOEXTENSIBLE</span><span style="font-family:'Courier New';font-size:10px;">=</span><span style="font-family:'Courier New';font-size:10px;">'YES'</span><span style="font-family:'Courier New';font-size:10px;">自增长时</span><span style="font-size:10px;">, 例如:</span><span style="font-family:'Courier New';font-size:10px;">初步分配10G</span><span style="font-family:'Courier New';font-size:10px;">,</span><span style="font-family:'Courier New';font-size:10px;">使用9.9G,</span><span style="font-family:'Courier New';font-size:10px;">原方法使用率</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">=</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;9.9</span><span style="font-family:'Courier New';font-size:10px;">/</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">10</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;*</span><span style="font-family:'Courier New';font-size:10px;">100</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">=</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;99</span><span style="font-family:'Courier New';font-size:10px;">%,</span><span style="font-family:'Courier New';font-size:10px;">而实际为</span><span style="font-family:'Courier New';font-size:10px;">=</span><span style="font-family:'Courier New';font-size:10px;">9.9</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">/</span><span style="font-family:'Courier New';font-size:10px;">总</span><span style="font-family:'Courier New';font-size:10px;">(</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">'smailfile'</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;≈</span><span style="font-family:'Courier New';font-size:10px;">32</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">G</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;)*</span><span style="font-family:'Courier New';font-size:10px;">100</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">=</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;31</span><span style="font-family:'Courier New';font-size:10px;">%;</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">2</span><span style="font-family:'Courier New';font-size:10px;">、</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">UNDO表空间循环使用,</span><span style="font-family:'Courier New';font-size:10px;">当大部分空间分配状态为UNEXPIRED</span><span style="font-size:10px;">,</span><span style="font-family:'Courier New';font-size:10px;">EXPIRED时,</span><span style="font-family:'Courier New';font-size:10px;">按照之前方式所算的使用率完全没有参考价值</span><span style="font-family:'Courier New';font-size:10px;">;</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">针对如上的2中情况</span><span style="font-size:10px;">&nbsp;,</span><span style="font-family:'Courier New';font-size:10px;">在如下sql已做改进.</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';"><br /> </span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">SQL</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;:</span> </div> <hr style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;margin:0px;padding:0px;background-color:#FFFFFF;" /> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">SELECT</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TBSP.TABLESPACE_NAME</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">,</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TBSP.TOTAL_GB</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;,</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TBSP.USE_GB</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;,</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TBSP.TOTAL_GB</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;-&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TBSP.USE_GB</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">FREE_GB</span><span style="font-family:'Courier New';font-size:10px;">,</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">ROUND</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;(</span><span style="font-family:'Courier New';font-size:10px;">TBSP.USE_GB</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">/&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TBSP.TOTAL_GB</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;*&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">100</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;,</span><span style="font-family:'Courier New';font-size:10px;">2</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">)&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">"USE%"</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">FROM</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;(&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">SELECT</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TOTAL.TABLESPACE_NAME</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">,</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TOTAL_GB</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;,</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">/*USE.TABLESPACE_NAME IS NULL 表示表空间使用为0'未分配段'*/</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">CASE</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">WHEN</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">USE.TABLESPACE_NAME</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">IS</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">NULL</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">THEN</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">0</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">/*各UNDO表空间ACTIVE状态USE_GB</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';"><i><span style="font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></i><span style="font-size:10px;">&nbsp;--ACTIVE表示目前仍活跃的事务相关回滚信息;</span></span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';"><i><span style="font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></i><span style="font-size:10px;">--UNEXPIRED表示虽然事务已经结束但回滚信息保留的时间仍未超过实例参数 UNDO_RETENTION所设定的值;</span></span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';"><i><span style="font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></i><span style="font-size:10px;">--EXPIRED表示回滚信息保留时间已超过UNDO_RETENTION所设定的值*/</span></span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">WHEN</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TOTAL.TABLESPACE_NAME</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">IN</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;(&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">SELECT</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">DISTINCT</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TABLESPACE_NAME</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">FROM</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">DBA_UNDO_EXTENTS</span><span style="font-family:'Courier New';font-size:10px;">)&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">THEN</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">SELECT</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">ROUND(NVL(SUM(BLOCKS) * 8 / 1024 / 1024,0), 2)</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">AS</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">"SIZE G"</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">FROM</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">DBA_UNDO_EXTENTS</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">WHERE</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">STATUS</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">=&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">'ACTIVE'</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">AND</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TABLESPACE_NAME</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">=</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;TOTAL.TABLESPACE_NAME</span><span style="font-family:'Courier New';font-size:10px;">)&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">ELSE</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">USE_GB</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">END</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;)&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">USE_GB</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">FROM</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;(</span><span style="font-family:'Courier New';font-size:10px;">/*表空间总大小*/</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">SELECT</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TABLESPACE_NAME</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">,</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">/*自动增长,OS层空间足够时,取MAXBYTES*/</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">ROUND</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;(</span><span style="font-family:'Courier New';font-size:10px;">SUM</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">((</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;CASE</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">WHEN</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">AUTOEXTENSIBLE</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">=&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">'YES'</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">THEN</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">MAXBYTES</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">ELSE</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">BYTES</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">END</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;) /&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1024</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">/&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1024</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;/&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1024</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;),&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">2</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">)&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TOTAL_GB</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">FROM</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">DBA_DATA_FILES</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">GROUP</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">BY</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TABLESPACE_NAME</span><span style="font-family:'Courier New';font-size:10px;">)&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TOTAL</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">LEFT</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">JOIN</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">(</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;/*表空间真实使用情况*/</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">SELECT</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TABLESPACE_NAME</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">,</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">ROUND</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;(</span><span style="font-family:'Courier New';font-size:10px;">SUM</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">(</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;BYTES</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;/&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1024</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;/&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1024</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">/&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1024</span><span style="font-family:'Courier New';font-size:10px;">),&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">2</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;)&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">USE_GB</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">FROM</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">DBA_SEGMENTS</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">GROUP</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">BY</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TABLESPACE_NAME</span><span style="font-family:'Courier New';font-size:10px;">)&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">USE</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">ON</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">USE.TABLESPACE_NAME</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">=&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TOTAL.TABLESPACE_NAME</span><span style="font-family:'Courier New';font-size:10px;">)&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TBSP</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">UNION</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">ALL</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">(</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;/*临时表空间使用情况*/</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">SELECT</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TABLESPACE_NAME</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">,</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">ROUND</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;(</span><span style="font-family:'Courier New';font-size:10px;">TF.TABLESPACE_SIZE</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">/&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1024</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;/&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1024</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;/&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1024</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">,&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">2</span><span style="font-family:'Courier New';font-size:10px;">)&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TABLESPACE_NAME</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;,</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">ROUND</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;((</span><span style="font-family:'Courier New';font-size:10px;">TF.TABLESPACE_SIZE</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">-&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TF.FREE_SPACE</span><span style="font-family:'Courier New';font-size:10px;">) /&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1024</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;/&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1024</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">/&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1024</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;,&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">2</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;)&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">USE_GB</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">,</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">ROUND</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;(</span><span style="font-family:'Courier New';font-size:10px;">TF.FREE_SPACE</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">/&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1024</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;/&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1024</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;/&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">1024</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">,&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">2</span><span style="font-family:'Courier New';font-size:10px;">)&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">FREE_GB</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;,</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">ROUND</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;((</span><span style="font-family:'Courier New';font-size:10px;">TF.TABLESPACE_SIZE</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">-&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TF.FREE_SPACE</span><span style="font-family:'Courier New';font-size:10px;">) /</span><span style="font-family:'Courier New';font-size:10px;">TF.TABLESPACE_SIZE</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;*&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">100</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">,</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;2</span><span style="font-family:'Courier New';font-size:10px;">)&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">"USE%"</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">FROM</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">DBA_TEMP_FREE_SPACE</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">TF</span><span style="font-family:'Courier New';font-size:10px;">);</span> </div> <hr style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;margin:0px;padding:0px;background-color:#FFFFFF;" /> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';"><br /> </span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">视图官方介绍</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">:</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <table border="1" cellpadding="2" cellspacing="0" width="100%"> <tbody> <tr> <td style="margin:0px;padding:0px;" valign="top"> <div align="left"> <span style="font-family:'Courier New';font-size:10px;">DBA_DATA_FILES</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;</span><a href="http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3083.htm#REFRN23049" style="text-decoration:none;color:#565656;"><span style="font-size:10px;">http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3083.htm#REFRN23049</span></a><span style="font-size:10px;">&nbsp;</span> </div> <div align="left"> <span style="font-family:'Courier New';font-size:10px;">DBA_SEGMENTS</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</span><a href="http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_4097.htm#REFRN23243" style="text-decoration:none;color:#565656;"><span style="font-size:10px;">http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_4097.htm#REFRN23243</span></a><span style="font-size:10px;">&nbsp;</span> </div> <div align="left"> <span style="font-family:'Courier New';font-size:10px;">DBA_TEMP_FREE_SPACE &nbsp;&nbsp;</span><a href="https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_5056.htm" style="text-decoration:none;color:#565656;"><span style="font-size:10px;">https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_5056.htm</span></a><span style="font-size:10px;">&nbsp;</span> </div> <div align="left"> <span style="font-family:'Courier New';font-size:10px;">DBA_UNDO_EXTENTS</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;&nbsp; &nbsp; &nbsp;</span><a href="http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_4171.htm#REFRN23299" style="text-decoration:none;color:#565656;"><span style="font-size:10px;">http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_4171.htm#REFRN23299</span></a><span style="font-size:10px;">&nbsp;</span> </div> </td> </tr> </tbody> </table> <div> <br /> </div> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';"><br /> </span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">提示:</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:10px;">&nbsp;若想针对各个DBF使用率进行查询,需要完善例如</span><span style="font-family:'Courier New';font-size:10px;">DBA_SEGMENTS.HEADER_FILE</span><span style="font-size:10px;">&nbsp;</span><span style="font-family:'Courier New';font-size:10px;">=</span><span style="font-family:'Courier New';font-size:10px;">&nbsp;DBA_DATA_FILES.FILE_ID...等</span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <span style="font-family:'Courier New';"><br /> </span> </div> <div align="left" style="font-family:微软雅黑;line-height:normal;orphans:2;white-space:normal;widows:2;font-size:medium;color:#666666;background-color:#FFFFFF;"> <br clear="none" /> <span style="line-height:26px;color:#797979;font-size:10px;">&nbsp;&nbsp;</span><span style="line-height:26px;color:#464646;font-size:10px;">【源于本人笔记】 若有书写错误,表达错误,请指正...</span><br clear="none" /> <div> <div style="height:auto;overflow:hidden;"> <div style="text-align:-webkit-auto;line-height:26px;"> <span style="line-height:normal;font-family:楷体;"><span style="color:#464646;"><br clear="none" /> </span></span> <hr style="margin:0px;padding:0px;line-height:normal;" /> <div style="line-height:normal;"> <span style="font-family:楷体;"><span style="color:#464646;"><span style="line-height:18px;font-family:NSimSun;font-size:10px;">此条目发表在 &nbsp;</span><span style="line-height:18px;font-family:NSimSun;font-size:10px;">&nbsp;</span><a href="http://blog.itpub.net/28602568/sid-170397-abstract-1/" shape="rect" style="text-decoration:none;color:#565656;line-height:18px;"><span style="font-family:NSimSun;font-size:10px;">SQL、SQL优化篇</span></a><span style="line-height:18px;font-family:NSimSun;font-size:10px;">&nbsp;</span><span style="line-height:18px;font-family:NSimSun;font-size:10px;">&nbsp;</span><span style="line-height:18px;"><span style="font-family:NSimSun;font-size:10px;">分类目录。将</span><a href="http://blog.itpub.net/28602568/viewspace-1770577/" shape="rect" style="text-decoration:none;color:#565656;"><span style="font-family:NSimSun;font-size:10px;">固定连接</span></a></span><span style="line-height:18px;font-family:NSimSun;font-size:10px;">加入收藏夹。</span></span></span> </div> <hr style="margin:0px;padding:0px;line-height:normal;" /> <span style="line-height:normal;font-family:楷体;"><br clear="none" /> </span> </div> </div> </div> </div> <br /> <span style="font-size:10px;"></span>
请登录后发表评论 登录
全部评论

注册时间:2013-03-13

  • 博文量
    127
  • 访问量
    2180591