濡備綍鏌ョ湅琛ㄧ┖闂翠娇鐢ㄦ儏鍐?/p>
2009-07-25 16:03
select e.tablespace_name
琛ㄧ┖闂?/p>
,round(e.
鎬荤┖闂?/p>
,0) "
鎬荤┖闂?/p>
(MB)",round(f.
鍓╀綑绌洪棿
,0) "
鍓╀綑绌洪棿
(MB)",round(f.
鍓╀綑绌洪棿
/e.
鎬荤┖闂?/p>
*100,0)
鍓╀綑绌洪棿鐧惧垎姣?/p>
from
(select tablespace_name,sum(bytes)/1024/1024
鎬荤┖闂?/p>
from dba_data_files group by
tablespace_name) e,
(select tablespace_name,sum(bytes)/1024/1024
鍓╀綑绌洪棿
from dba_free_space group
by tablespace_name) f
where e.tablespace_name=f.tablespace_name
order by
鍓╀綑绌洪棿鐧惧垎姣?/p>
1.
鏌ョ湅鎵�鏈夎〃绌洪棿澶у皬
Sql
浠ｇ爜
1.
select
tablespace_name,
sum
(bytes)/1024/1024
from
dba_data_files
2.
roup
by
tablespace_name;
2.
鏈娇鐢ㄧ殑琛ㄧ┖闂村ぇ灏?/p>
Sql
浠ｇ爜
1.
select
tablespace_name,
sum
(bytes)/1024/1024
from
dba_free_space
2.
group
by
tablespace_name;
3.
鎵�浠ヤ娇鐢ㄧ┖闂村彲浠ヨ繖鏍疯绠?/p>
Sql
浠ｇ爜
1.
select
a.tablespace_name,total,
free
,total-
free
used
from
2.
(
select
tablespace_name,
sum
(bytes)/1024/1024 total
from
dba_data_files
3.
group
by
tablespace_name) a,
4.
(
select
tablespace_name,
sum
(bytes)/1024/1024
free
from
dba_free_space
5.
group
by
tablespace_name) b
6.
where
a.tablespace_name=b.tablespace_name;
4.
杩樻湁鍦ㄥ懡浠よ鎯呭喌涓嬪浣曞皢缁撴灉鏀惧埌涓�涓枃浠堕噷銆?/p>
Sql
浠ｇ爜