OS 환경 : Oracle Linux 8.4 (64bit)
DB 환경 : Oracle Database 19.27.0.0
방법 : 오라클 19c 테스트용 테이블스페이스 및 데이터파일 여러개 생성 쿼리
asm 환경에서 테스트용 테이블스페이스 및 데이터파일 여러개 생성하는 쿼리임
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
SQL>
-- 테이블스페이스 생성 및 10MB datafile 20개 추가
BEGIN
FOR ts_num IN 1..10 LOOP
-- 첫 번째 datafile 포함한 테이블스페이스 생성
EXECUTE IMMEDIATE 'CREATE TABLESPACE test' || ts_num || ' DATAFILE SIZE 10M';
-- 나머지 19개의 datafile 추가
FOR df_num IN 2..20 LOOP
EXECUTE IMMEDIATE 'ALTER TABLESPACE test' || ts_num || ' ADD DATAFILE SIZE 10M';
END LOOP;
END LOOP;
END;
/
|
위 쿼리 사용전 db_create_file_dest 파라미터가 적용되어 있어야함
|
1
2
3
4
5
|
SQL> show parameter db_create_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string +DATA
|
그리고 db_files 파라미터도 200개 이상으로 설정되어 있어야함(나의 경우 200으로 설정해두고 plsql을 실행해서 일부만 생성됨)
|
1
2
3
4
5
|
SQL> show parameter db_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_files integer 400
|
생성후 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
|
SQL>
set lines 200 pages 1000
col tablespace_name for a20
col file_name for a70
select tablespace_name, file_id, file_name, round(bytes/1024/1024/1024, 2) gb,
round(maxbytes/1024/1024/1024, 2) max_gb, autoextensible, status, online_status from dba_data_files
union all
select tablespace_name, file_id, file_name, round(bytes/1024/1024/1024, 2) gb,
round(maxbytes/1024/1024/1024, 2) max_gb, autoextensible, status, null from dba_temp_files order by 2;
TABLESPACE_NAME FILE_ID FILE_NAME GB MAX_GB AUT STATUS ONLINE_
-------------------- ---------- ---------------------------------------------------------------------- ---------- ---------- --- --------- -------
SYSTEM 1 +DATA/ORA19DB/DATAFILE/system.274.1201188459 1.46 0 NO AVAILABLE SYSTEM
TEMP 1 +DATA/ORA19DB/TEMPFILE/temp.277.1201188465 1 32 YES ONLINE
SYSAUX 2 +DATA/ORA19DB/DATAFILE/sysaux.275.1201188461 1 0 NO AVAILABLE ONLINE
UNDOTBS1 3 +DATA/ORA19DB/DATAFILE/undotbs1.276.1201188463 1 0 NO AVAILABLE ONLINE
UNDOTBS2 4 +DATA/ORA19DB/DATAFILE/undotbs2.278.1201188471 1 0 NO AVAILABLE ONLINE
USERS 5 +DATA/ORA19DB/DATAFILE/users.279.1201188471 0 0 NO AVAILABLE ONLINE
TEST1 6 +DATA/ORA19DB/DATAFILE/test1.307.1207644447 .01 0 NO AVAILABLE ONLINE
TEST1 7 +DATA/ORA19DB/DATAFILE/test1.304.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 8 +DATA/ORA19DB/DATAFILE/test1.306.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 9 +DATA/ORA19DB/DATAFILE/test1.308.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 10 +DATA/ORA19DB/DATAFILE/test1.309.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 11 +DATA/ORA19DB/DATAFILE/test1.311.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 12 +DATA/ORA19DB/DATAFILE/test1.312.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 13 +DATA/ORA19DB/DATAFILE/test1.313.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 14 +DATA/ORA19DB/DATAFILE/test1.314.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 15 +DATA/ORA19DB/DATAFILE/test1.315.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 16 +DATA/ORA19DB/DATAFILE/test1.316.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 17 +DATA/ORA19DB/DATAFILE/test1.317.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 18 +DATA/ORA19DB/DATAFILE/test1.318.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 19 +DATA/ORA19DB/DATAFILE/test1.319.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 20 +DATA/ORA19DB/DATAFILE/test1.320.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 21 +DATA/ORA19DB/DATAFILE/test1.321.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 22 +DATA/ORA19DB/DATAFILE/test1.322.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 23 +DATA/ORA19DB/DATAFILE/test1.323.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 24 +DATA/ORA19DB/DATAFILE/test1.324.1207644449 .01 0 NO AVAILABLE ONLINE
TEST1 25 +DATA/ORA19DB/DATAFILE/test1.325.1207644449 .01 0 NO AVAILABLE ONLINE
TEST2 26 +DATA/ORA19DB/DATAFILE/test2.326.1207644449 .01 0 NO AVAILABLE ONLINE
TEST2 27 +DATA/ORA19DB/DATAFILE/test2.327.1207644449 .01 0 NO AVAILABLE ONLINE
TEST2 28 +DATA/ORA19DB/DATAFILE/test2.328.1207644449 .01 0 NO AVAILABLE ONLINE
TEST2 29 +DATA/ORA19DB/DATAFILE/test2.329.1207644449 .01 0 NO AVAILABLE ONLINE
TEST2 30 +DATA/ORA19DB/DATAFILE/test2.330.1207644449 .01 0 NO AVAILABLE ONLINE
TEST2 31 +DATA/ORA19DB/DATAFILE/test2.331.1207644449 .01 0 NO AVAILABLE ONLINE
TEST2 32 +DATA/ORA19DB/DATAFILE/test2.332.1207644451 .01 0 NO AVAILABLE ONLINE
TEST2 33 +DATA/ORA19DB/DATAFILE/test2.333.1207644451 .01 0 NO AVAILABLE ONLINE
TEST2 34 +DATA/ORA19DB/DATAFILE/test2.334.1207644451 .01 0 NO AVAILABLE ONLINE
TEST2 35 +DATA/ORA19DB/DATAFILE/test2.335.1207644451 .01 0 NO AVAILABLE ONLINE
TEST2 36 +DATA/ORA19DB/DATAFILE/test2.336.1207644451 .01 0 NO AVAILABLE ONLINE
TEST2 37 +DATA/ORA19DB/DATAFILE/test2.337.1207644451 .01 0 NO AVAILABLE ONLINE
TEST2 38 +DATA/ORA19DB/DATAFILE/test2.338.1207644451 .01 0 NO AVAILABLE ONLINE
TEST2 39 +DATA/ORA19DB/DATAFILE/test2.339.1207644451 .01 0 NO AVAILABLE ONLINE
TEST2 40 +DATA/ORA19DB/DATAFILE/test2.340.1207644451 .01 0 NO AVAILABLE ONLINE
TEST2 41 +DATA/ORA19DB/DATAFILE/test2.341.1207644451 .01 0 NO AVAILABLE ONLINE
TEST2 42 +DATA/ORA19DB/DATAFILE/test2.342.1207644451 .01 0 NO AVAILABLE ONLINE
TEST2 43 +DATA/ORA19DB/DATAFILE/test2.343.1207644451 .01 0 NO AVAILABLE ONLINE
TEST2 44 +DATA/ORA19DB/DATAFILE/test2.344.1207644451 .01 0 NO AVAILABLE ONLINE
TEST2 45 +DATA/ORA19DB/DATAFILE/test2.345.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 46 +DATA/ORA19DB/DATAFILE/test3.346.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 47 +DATA/ORA19DB/DATAFILE/test3.347.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 48 +DATA/ORA19DB/DATAFILE/test3.348.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 49 +DATA/ORA19DB/DATAFILE/test3.349.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 50 +DATA/ORA19DB/DATAFILE/test3.350.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 51 +DATA/ORA19DB/DATAFILE/test3.351.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 52 +DATA/ORA19DB/DATAFILE/test3.352.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 53 +DATA/ORA19DB/DATAFILE/test3.353.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 54 +DATA/ORA19DB/DATAFILE/test3.354.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 55 +DATA/ORA19DB/DATAFILE/test3.355.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 56 +DATA/ORA19DB/DATAFILE/test3.356.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 57 +DATA/ORA19DB/DATAFILE/test3.357.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 58 +DATA/ORA19DB/DATAFILE/test3.358.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 59 +DATA/ORA19DB/DATAFILE/test3.359.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 60 +DATA/ORA19DB/DATAFILE/test3.360.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 61 +DATA/ORA19DB/DATAFILE/test3.361.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 62 +DATA/ORA19DB/DATAFILE/test3.362.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 63 +DATA/ORA19DB/DATAFILE/test3.363.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 64 +DATA/ORA19DB/DATAFILE/test3.364.1207644451 .01 0 NO AVAILABLE ONLINE
TEST3 65 +DATA/ORA19DB/DATAFILE/test3.365.1207644451 .01 0 NO AVAILABLE ONLINE
TEST4 66 +DATA/ORA19DB/DATAFILE/test4.366.1207644451 .01 0 NO AVAILABLE ONLINE
TEST4 67 +DATA/ORA19DB/DATAFILE/test4.367.1207644451 .01 0 NO AVAILABLE ONLINE
TEST4 68 +DATA/ORA19DB/DATAFILE/test4.368.1207644451 .01 0 NO AVAILABLE ONLINE
TEST4 69 +DATA/ORA19DB/DATAFILE/test4.369.1207644451 .01 0 NO AVAILABLE ONLINE
TEST4 70 +DATA/ORA19DB/DATAFILE/test4.370.1207644451 .01 0 NO AVAILABLE ONLINE
TEST4 71 +DATA/ORA19DB/DATAFILE/test4.371.1207644451 .01 0 NO AVAILABLE ONLINE
TEST4 72 +DATA/ORA19DB/DATAFILE/test4.372.1207644451 .01 0 NO AVAILABLE ONLINE
TEST4 73 +DATA/ORA19DB/DATAFILE/test4.373.1207644451 .01 0 NO AVAILABLE ONLINE
TEST4 74 +DATA/ORA19DB/DATAFILE/test4.374.1207644453 .01 0 NO AVAILABLE ONLINE
TEST4 75 +DATA/ORA19DB/DATAFILE/test4.375.1207644453 .01 0 NO AVAILABLE ONLINE
TEST4 76 +DATA/ORA19DB/DATAFILE/test4.376.1207644453 .01 0 NO AVAILABLE ONLINE
TEST4 77 +DATA/ORA19DB/DATAFILE/test4.377.1207644453 .01 0 NO AVAILABLE ONLINE
TEST4 78 +DATA/ORA19DB/DATAFILE/test4.378.1207644453 .01 0 NO AVAILABLE ONLINE
TEST4 79 +DATA/ORA19DB/DATAFILE/test4.379.1207644453 .01 0 NO AVAILABLE ONLINE
TEST4 80 +DATA/ORA19DB/DATAFILE/test4.380.1207644453 .01 0 NO AVAILABLE ONLINE
TEST4 81 +DATA/ORA19DB/DATAFILE/test4.381.1207644453 .01 0 NO AVAILABLE ONLINE
TEST4 82 +DATA/ORA19DB/DATAFILE/test4.382.1207644453 .01 0 NO AVAILABLE ONLINE
TEST4 83 +DATA/ORA19DB/DATAFILE/test4.383.1207644453 .01 0 NO AVAILABLE ONLINE
TEST4 84 +DATA/ORA19DB/DATAFILE/test4.384.1207644453 .01 0 NO AVAILABLE ONLINE
TEST4 85 +DATA/ORA19DB/DATAFILE/test4.385.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 86 +DATA/ORA19DB/DATAFILE/test5.386.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 87 +DATA/ORA19DB/DATAFILE/test5.387.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 88 +DATA/ORA19DB/DATAFILE/test5.388.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 89 +DATA/ORA19DB/DATAFILE/test5.389.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 90 +DATA/ORA19DB/DATAFILE/test5.390.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 91 +DATA/ORA19DB/DATAFILE/test5.391.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 92 +DATA/ORA19DB/DATAFILE/test5.392.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 93 +DATA/ORA19DB/DATAFILE/test5.393.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 94 +DATA/ORA19DB/DATAFILE/test5.394.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 95 +DATA/ORA19DB/DATAFILE/test5.395.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 96 +DATA/ORA19DB/DATAFILE/test5.396.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 97 +DATA/ORA19DB/DATAFILE/test5.397.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 98 +DATA/ORA19DB/DATAFILE/test5.398.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 99 +DATA/ORA19DB/DATAFILE/test5.399.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 100 +DATA/ORA19DB/DATAFILE/test5.400.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 101 +DATA/ORA19DB/DATAFILE/test5.401.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 102 +DATA/ORA19DB/DATAFILE/test5.402.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 103 +DATA/ORA19DB/DATAFILE/test5.403.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 104 +DATA/ORA19DB/DATAFILE/test5.404.1207644453 .01 0 NO AVAILABLE ONLINE
TEST5 105 +DATA/ORA19DB/DATAFILE/test5.405.1207644453 .01 0 NO AVAILABLE ONLINE
TEST6 106 +DATA/ORA19DB/DATAFILE/test6.406.1207644453 .01 0 NO AVAILABLE ONLINE
TEST6 107 +DATA/ORA19DB/DATAFILE/test6.407.1207644453 .01 0 NO AVAILABLE ONLINE
TEST6 108 +DATA/ORA19DB/DATAFILE/test6.408.1207644453 .01 0 NO AVAILABLE ONLINE
TEST6 109 +DATA/ORA19DB/DATAFILE/test6.409.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 110 +DATA/ORA19DB/DATAFILE/test6.410.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 111 +DATA/ORA19DB/DATAFILE/test6.411.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 112 +DATA/ORA19DB/DATAFILE/test6.412.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 113 +DATA/ORA19DB/DATAFILE/test6.413.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 114 +DATA/ORA19DB/DATAFILE/test6.414.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 115 +DATA/ORA19DB/DATAFILE/test6.415.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 116 +DATA/ORA19DB/DATAFILE/test6.416.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 117 +DATA/ORA19DB/DATAFILE/test6.417.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 118 +DATA/ORA19DB/DATAFILE/test6.418.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 119 +DATA/ORA19DB/DATAFILE/test6.419.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 120 +DATA/ORA19DB/DATAFILE/test6.420.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 121 +DATA/ORA19DB/DATAFILE/test6.421.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 122 +DATA/ORA19DB/DATAFILE/test6.422.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 123 +DATA/ORA19DB/DATAFILE/test6.423.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 124 +DATA/ORA19DB/DATAFILE/test6.424.1207644455 .01 0 NO AVAILABLE ONLINE
TEST6 125 +DATA/ORA19DB/DATAFILE/test6.425.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 126 +DATA/ORA19DB/DATAFILE/test7.426.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 127 +DATA/ORA19DB/DATAFILE/test7.427.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 128 +DATA/ORA19DB/DATAFILE/test7.428.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 129 +DATA/ORA19DB/DATAFILE/test7.429.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 130 +DATA/ORA19DB/DATAFILE/test7.430.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 131 +DATA/ORA19DB/DATAFILE/test7.431.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 132 +DATA/ORA19DB/DATAFILE/test7.432.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 133 +DATA/ORA19DB/DATAFILE/test7.433.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 134 +DATA/ORA19DB/DATAFILE/test7.434.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 135 +DATA/ORA19DB/DATAFILE/test7.435.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 136 +DATA/ORA19DB/DATAFILE/test7.436.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 137 +DATA/ORA19DB/DATAFILE/test7.437.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 138 +DATA/ORA19DB/DATAFILE/test7.438.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 139 +DATA/ORA19DB/DATAFILE/test7.439.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 140 +DATA/ORA19DB/DATAFILE/test7.440.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 141 +DATA/ORA19DB/DATAFILE/test7.441.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 142 +DATA/ORA19DB/DATAFILE/test7.442.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 143 +DATA/ORA19DB/DATAFILE/test7.443.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 144 +DATA/ORA19DB/DATAFILE/test7.444.1207644455 .01 0 NO AVAILABLE ONLINE
TEST7 145 +DATA/ORA19DB/DATAFILE/test7.445.1207644455 .01 0 NO AVAILABLE ONLINE
TEST8 146 +DATA/ORA19DB/DATAFILE/test8.446.1207644455 .01 0 NO AVAILABLE ONLINE
TEST8 147 +DATA/ORA19DB/DATAFILE/test8.447.1207644455 .01 0 NO AVAILABLE ONLINE
TEST8 148 +DATA/ORA19DB/DATAFILE/test8.448.1207644455 .01 0 NO AVAILABLE ONLINE
TEST8 149 +DATA/ORA19DB/DATAFILE/test8.449.1207644455 .01 0 NO AVAILABLE ONLINE
TEST8 150 +DATA/ORA19DB/DATAFILE/test8.450.1207644455 .01 0 NO AVAILABLE ONLINE
TEST8 151 +DATA/ORA19DB/DATAFILE/test8.451.1207644455 .01 0 NO AVAILABLE ONLINE
TEST8 152 +DATA/ORA19DB/DATAFILE/test8.452.1207644457 .01 0 NO AVAILABLE ONLINE
TEST8 153 +DATA/ORA19DB/DATAFILE/test8.453.1207644457 .01 0 NO AVAILABLE ONLINE
TEST8 154 +DATA/ORA19DB/DATAFILE/test8.454.1207644457 .01 0 NO AVAILABLE ONLINE
TEST8 155 +DATA/ORA19DB/DATAFILE/test8.455.1207644457 .01 0 NO AVAILABLE ONLINE
TEST8 156 +DATA/ORA19DB/DATAFILE/test8.456.1207644457 .01 0 NO AVAILABLE ONLINE
TEST8 157 +DATA/ORA19DB/DATAFILE/test8.457.1207644457 .01 0 NO AVAILABLE ONLINE
TEST8 158 +DATA/ORA19DB/DATAFILE/test8.458.1207644457 .01 0 NO AVAILABLE ONLINE
TEST8 159 +DATA/ORA19DB/DATAFILE/test8.459.1207644457 .01 0 NO AVAILABLE ONLINE
TEST8 160 +DATA/ORA19DB/DATAFILE/test8.460.1207644457 .01 0 NO AVAILABLE ONLINE
TEST8 161 +DATA/ORA19DB/DATAFILE/test8.461.1207644457 .01 0 NO AVAILABLE ONLINE
TEST8 162 +DATA/ORA19DB/DATAFILE/test8.462.1207644457 .01 0 NO AVAILABLE ONLINE
TEST8 163 +DATA/ORA19DB/DATAFILE/test8.463.1207644457 .01 0 NO AVAILABLE ONLINE
TEST8 164 +DATA/ORA19DB/DATAFILE/test8.464.1207644457 .01 0 NO AVAILABLE ONLINE
TEST8 165 +DATA/ORA19DB/DATAFILE/test8.465.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 166 +DATA/ORA19DB/DATAFILE/test9.466.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 167 +DATA/ORA19DB/DATAFILE/test9.467.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 168 +DATA/ORA19DB/DATAFILE/test9.468.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 169 +DATA/ORA19DB/DATAFILE/test9.469.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 170 +DATA/ORA19DB/DATAFILE/test9.470.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 171 +DATA/ORA19DB/DATAFILE/test9.471.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 172 +DATA/ORA19DB/DATAFILE/test9.472.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 173 +DATA/ORA19DB/DATAFILE/test9.473.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 174 +DATA/ORA19DB/DATAFILE/test9.474.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 175 +DATA/ORA19DB/DATAFILE/test9.475.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 176 +DATA/ORA19DB/DATAFILE/test9.476.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 177 +DATA/ORA19DB/DATAFILE/test9.477.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 178 +DATA/ORA19DB/DATAFILE/test9.478.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 179 +DATA/ORA19DB/DATAFILE/test9.479.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 180 +DATA/ORA19DB/DATAFILE/test9.480.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 181 +DATA/ORA19DB/DATAFILE/test9.481.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 182 +DATA/ORA19DB/DATAFILE/test9.482.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 183 +DATA/ORA19DB/DATAFILE/test9.483.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 184 +DATA/ORA19DB/DATAFILE/test9.484.1207644457 .01 0 NO AVAILABLE ONLINE
TEST9 185 +DATA/ORA19DB/DATAFILE/test9.485.1207644457 .01 0 NO AVAILABLE ONLINE
TEST10 186 +DATA/ORA19DB/DATAFILE/test10.486.1207644457 .01 0 NO AVAILABLE ONLINE
TEST10 187 +DATA/ORA19DB/DATAFILE/test10.487.1207644457 .01 0 NO AVAILABLE ONLINE
TEST10 188 +DATA/ORA19DB/DATAFILE/test10.488.1207644457 .01 0 NO AVAILABLE ONLINE
TEST10 189 +DATA/ORA19DB/DATAFILE/test10.489.1207644457 .01 0 NO AVAILABLE ONLINE
TEST10 190 +DATA/ORA19DB/DATAFILE/test10.490.1207644457 .01 0 NO AVAILABLE ONLINE
TEST10 191 +DATA/ORA19DB/DATAFILE/test10.491.1207644457 .01 0 NO AVAILABLE ONLINE
TEST10 192 +DATA/ORA19DB/DATAFILE/test10.492.1207644457 .01 0 NO AVAILABLE ONLINE
TEST10 193 +DATA/ORA19DB/DATAFILE/test10.493.1207644457 .01 0 NO AVAILABLE ONLINE
TEST10 194 +DATA/ORA19DB/DATAFILE/test10.494.1207644457 .01 0 NO AVAILABLE ONLINE
TEST10 195 +DATA/ORA19DB/DATAFILE/test10.495.1207644457 .01 0 NO AVAILABLE ONLINE
TEST10 196 +DATA/ORA19DB/DATAFILE/test10.496.1207644457 .01 0 NO AVAILABLE ONLINE
TEST10 197 +DATA/ORA19DB/DATAFILE/test10.497.1207644459 .01 0 NO AVAILABLE ONLINE
TEST10 198 +DATA/ORA19DB/DATAFILE/test10.498.1207644459 .01 0 NO AVAILABLE ONLINE
TEST10 199 +DATA/ORA19DB/DATAFILE/test10.499.1207644459 .01 0 NO AVAILABLE ONLINE
TEST10 200 +DATA/ORA19DB/DATAFILE/test10.500.1207644459 .01 0 NO AVAILABLE ONLINE
201 rows selected.
|
참조 :
'ORACLE > Sql' 카테고리의 다른 글
| 오라클 19c Hugepages 설정 스크립트 최신버전 및 수동계산 (1) | 2025.09.28 |
|---|---|
| 오라클 19c 유저 100개, 테이블 100개, 인덱스 100개, 데이터 1000건 생성 (0) | 2025.08.10 |
| 오라클 23ai cdb, pdb, 리스너 전체 기동 및 정지 스크립트 (0) | 2025.05.18 |
| 오라클 19c 유저, 백그라운드 프로세스 pga 사용량 확인 (0) | 2024.05.01 |
| DBMS_SPACE.UNUSED_SPACE 한번에 여러 세그먼트 조회 (0) | 2024.04.10 |