oracle表空间管理汇总.docx
需积分: 12 142 浏览量
2022-09-20
16:25:51
上传
评论
收藏 14KB DOCX 举报
oracle 表空间常用汇总
1.表空间使用率查询
Set pagesize 50
Set linesize
200
column "Tablespace" format a20
column "Used MB" format 99,999,999
column "Free MB" format 99,999,999
column "Total MB" format 99,999,999
select
fs.tablespace_name
"Tablespace",
(df.totalspace - fs.freespace)
"Used MB",
fs.freespace "Free MB",
df.totalspace "Total MB",
df.autoextend "Autoextend
MB",
100 * (fs.freespace / df.totalspace) "Pct Free",
100 * ((df.totalspace - fs.freespace) / df.totalspace) "Pct Use"
from
(select
tablespace_name,
Sum(maxbytes)/1048576 autoextend,
round(sum(bytes)/1048576) TotalSpace
from
dba_data_files
group by
tablespace_name
) df,
(select
tablespace_name,
round(sum(bytes)/1048576) FreeSpace
from
dba_free_space
评论0
最新资源