Oracle 日常积累
查看在表空间dvbcetus_sup中使用空间最多的前10个表:
select * from (
select u.segment_name, u.bytes/1024/1024 || 'M'
from user_segments u
where u.tablespace_name = 'DVBCETUS_SUP'
order by u.bytes desc ) aa
where rownum <= 10
Oracle 日常积累
查看在表空间dvbcetus_sup中使用空间最多的前10个表:
select * from (
select u.segment_name, u.bytes/1024/1024 || 'M'
from user_segments u
where u.tablespace_name = 'DVBCETUS_SUP'
order by u.bytes desc ) aa
where rownum <= 10