select distinct tablespace_name
from dba_tables
where owner in ('BOSS', 'MD_QZY', 'SMART', 'SRDQ','RIMS')
union
select distinct tablespace_name
from dba_indexes
where owner in ('BOSS', 'MD_QZY', 'SMART', 'SRDQ','RIMS')
union
select distinct tablespace_name
from dba_tab_partitions
where table_owner in ('BOSS', 'MD_QZY', 'SMART', 'SRDQ','RIMS')
UNION
select DISTINCT TABLESPACE_NAME
FROM DBA_IND_PARTITIONS
where INDEX_owner in ('BOSS', 'MD_QZY', 'SMART', 'SRDQ','RIMS')
UNION
select distinct tablespace_name
from dba_tab_subpartitions
where table_owner in ('BOSS', 'MD_QZY', 'SMART', 'SRDQ','RIMS')
UNION
select DISTINCT TABLESPACE_NAME
FROM DBA_IND_SUBPARTITIONS
where INDEX_owner in ('BOSS', 'MD_QZY', 'SMART', 'SRDQ','RIMS');
54个：
RETURN01_01
RIMS
SMART
SMART_DBAK1
SMART_DBAK2
SMART_DT1
SMART_DT2
SMART_DWMOB
SMART_DXBAO01
SMART_DXBAO02
SMART_IMDATA
SMART_INDEX
SMART_INDEX02
SMART_INDEX03
SMART_INDEX05
SMART_INDEX06
SMART_JINGDONG
SMART_JT1
SMART_MOBAK
SMART_MOBAK00
SMART_MOBAK02
SMART_MOBAK03
SMART_MOBAK04
SMART_MOBIBAK
SMART_MOQU
SMART_MTQ
SMART_NEWSYS01
SMART_NMSGID01
SMART_NWHITELIST
SMART_NWHITELIST_MS
SMART_OPINDEX
SMART_OPLOG01
SMART_OPLOG02
SMART_OPLOG03
SMART_OPLOG04
SMART_OPLOG05
SMART_OVERFLOW
SMART_PUSHRETURN
SMART_QUEUE
SMART_SHENJI
SMART_SNBLST
SMART_SRPINDEX
SMART_STSRRT
SMART_STSRRTINDEX
SMART_TJ01
SMART_TONGJI00
SMART_TONGJI01
SMART_TONGJI02
SMART_TONGJI03
SMART_ZHIFU
SMART_ZHIXINGLI
T_PROFIT_STATIS
T_PROFIT_STATIS_IDX
1、查看表空间
set lin 200 pages 1000
select * from (select tablespace_name,round(sum(bytes/1024/1024/1024),2) total_G,
round(sum(maxbytes/1024/1024/1024),2) max_extended_G,
round(sum((maxbytes-bytes)/1024/1024/1024),2) need_extend_G,
round(sum(bytes)/sum(maxbytes),4)*100 "MAXRate"
from dba_data_files group by tablespace_name
union
select tablespace_name,round(sum(bytes/1024/1024/1024),2) ,
round(sum(maxbytes/1024/1024/1024),2) ,
round(sum((maxbytes-bytes)/1024/1024/1024),2) ,
round(sum(bytes)/sum(maxbytes),4)*100
from dba_temp_files group by tablespace_name)
;
TABLESPACE_NAME
TOTAL_G MAX_EXTENDED_G NEED_EXTEND_G MAXRate
------------------------------ ---------- -------------- ------------- ----------
UNDOTBS1
41.77
64
22.23
65.26
SMART_TONGJI00
40.19
64
23.81
62.8
SMART_INDEX06
33.11
64
30.89
51.73
SMART_MOBAK
14.02
32
17.98
43.81
SMART_INDEX
13.24
32
18.76
41.37
SMART_INDEX03
24.34
64
39.66
38.03
SMART_SHENJI
10.42
32
21.58
32.58
SMART
10.13
32
21.87
31.66
SMART_NWHITELIST
8.24
32
23.76
25.76
SMART_MOBAK02
15.97
64
48.03
24.95
SMART_MOBAK00
15.12
64
48.88
23.62
SMART_MOBAK03
21.99
96
74.01
22.91
SMART_MOBAK04
14.58
64
49.42
22.78
STPTBL
6.93
32
25.07
21.67
SMART_TONGJI01
13.48
64
50.52
21.06
SMART_INDEX02
5.49
32
26.51
17.15
SMART_SNBLST
2.99
32
29.01
9.34
SMART_STSRRT
2.66
32
29.34
8.3
SYSTEM
2.42
32
29.58
7.57
SMART_ZHIFU
4.51
64
59.49
7.04
SMART_DT2
1.81
32
30.19
5.65
SMART_OVERFLOW
1.44
32
30.56
4.5
SMART_QUEUE
1.26
32
30.74
3.94
SMART_DT1
1.22
32
30.78
3.8
T_PROFIT_STATIS
2
64
62
3.13
T_PROFIT_STATIS_IDX
2
64
62
3.13
SMART_OPLOG01
2.93
96
93.07
3.05
SMART_OPLOG03
2.93
96
93.07
3.05
SMART_OPLOG05
2.93
96
93.07
3.05
SMART_OPLOG06
2.93
96
93.07
3.05
SMART_OPLOG04
2.93
96
93.07
3.05
SMART_OPLOG02
2.93
96
93.07
3.05
SMART_TONGJI02
.62
32
31.38
1.92
SMART_MTQ
.61
32
31.39
1.89
SMART_INDEX05
.57
32
31.43
1.77
SMART_NWHITELIST_MS
.52
32
31.48
1.62
SMART_MOQU
.42
32
31.58
1.3
SMART_DBAK1
.32
32
31.68
1.01
RETURN01_01
.24
32
31.76
.75
SMART_DBAK2
.2
32
31.8
.61
SMART_INDEX04
.2
32
31.8
.61
SMART_JINGDONG
.39
64
63.61
.61
SMART_OPINDEX
.59
96
95.41
.61
SMART_TJ01
.2
32
31.8
.61
SMART_TONGJI03
.2
32
31.8
.61
SMART_MOBAK01
.59
96
95.41
.61
SMART_DXBAO02
.2
32
31.8
.61
SMART_DXBAO01
.2
32
31.8
.61
SMART_JT1
.15
32
31.85
.46
SMART_SRPINDEX
.14
32
31.86
.44
EXAMPLE
.12
32
31.88
.37
SMART_IMDATA
.1
32
31.9
.31
SMART_ZHIXINGLI
.1
32
31.9
.31
SMART_NEWSYS01
.1
32
31.9
.31
SMART_DWMOB
.05
32
31.95
.15
SMART_MOBIBAK
.05
32
31.95
.15
SMART_NMSGID01
.05
32
31.95
.15
SMART_PUSHRETURN
.05
32
31.95
.15
SMART_STSRRTINDEX
.05
32
31.95
.15
SMART_SRNRINDEX
.05
32
31.95
.15
XDB
.04
32
31.96
.14
INDX
.02
32
31.98
.08
USERS
.02
32
31.98
.08
BOSS
.02
32
31.98
.06
ODM
.02
32
31.98
.06
CWMLITE
.02
32
31.98
.06
DRSYS
.02
32
31.98
.06
TOOLS
.01
32
31.99
.03
68 rows selected.
查看99.206
sys@ZKMOBILE(192.168.99.206)>select file_name from dba_data_files union select file_name from dba_temp_files;