|
|
当前用户默认表空间使用情况
select tablespacename,
sum(totalContent),
sum(usecontent),
sum(sparecontent),
avg(sparepercent)
from (SELECT b.file_id as id,
b.tablespace_name as tablespacename,
b.bytes as totalContent,
(b.bytes - sum(nvl(a.bytes, 0))) as usecontent,
sum(nvl(a.bytes, 0)) as sparecontent,
sum(nvl(a.bytes, 0)) / (b.bytes) * 100 as sparepercent
FROM dba_free_space a, dba_data_files b
WHERE a.file_id = b.file_id
and b.tablespace_name =
(select default_tablespace
from dba_users
where username = user)
group by b.tablespace_name, b.file_name, b.file_id, b.bytes)
GROUP BY tablespacename
执行效果：
单张表使用情况
select segment_name, bytes
from dba_segments
where segment_name = '表名'
and owner = USER;
执行效果：
|
|
发表于 2020-6-8 17:14:02
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
楼主
发表于 2020-6-11 15:40:48
