ORACLE临时
表
关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf
空间的清理_0
考研屋 www.kaoyanwu.com 提供各大机构考研、公务员、四六级辅导视频课程
ORACLE临时表空间的清理 --查看使用率 column TablespaceName format a40 heading 'Tablespace Name' column TotalUsedBytes format 9,999,999,999 heading 'File
Sizes|(K)' column TotalFreeBytes format 9,999,999,999 heading 'Free Bytes|(K)' column
FreeRatio format 990.99 heading 'Free|(%)' column TotalExtensibleBytes format 9,999,999,999 heading 'Extensible|Sizes (K)' column TotalExtends format 9999 heading 'Ext'
compute sum label 'Total:' of TotalFreeBytes TotalUsedBytes TotalExtensibleBytes on report
break on report select b.TablespaceName, round(sum(b.UsedByte) / 1024) TotalUsedBytes, round(sum(a.FreeByte) / 1024) TotalFreeBytes,
round(sum(b.ExtensibleByte) / 1024) TotalExtensibleBytes, round(sum(a.FreeByte + b.ExtensibleByte) * 100 / sum(b.UsedByte + b.ExtensibleByte), 2) FreeRatio, sum(a.Extend) TotalExtends from (select sum(bytes) FreeByte, count(*) Extend, file_id FileID,
tablespace_name TablespaceName from dba_free_space group by file_id,
tablespace_name union all select sum(bytes_free) FreeByte, count(*) Extend,
file_id FileID, tablespace_name TablespaceName from v$temp_space_header group
by file_id, tablespace_name) a, (select decode(autoextensible, 'YES', decode(sign(maxbytes - bytes), 1, maxbytes - bytes, 0), 0) ExtensibleByte, bytes UsedByte,
file_id FileID, tablespace_name TablespaceName from dba_data_files union all
select decode(autoextensible, 'YES', decode(sign(maxbytes - bytes), 1, maxbytes - bytes, 0), 0)
ExtensibleByte, bytes UsedByte, file_id FileID, tablespace_name TablespaceName
from dba_temp_files) b where b.FileID = a.FileID(+) and b.TablespaceName= a.TablespaceN
考研屋 www.kaoyanwu.com :提供各大机构考研、公务员、四六级辅导视频课程
考研路上必备的网站----考研屋 www.kaoyanwu.com