bash-3.00$ sqlplus omcr/dt
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 20 10:18:39 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> set timing on
SQL> ;
SP2-0223: No lines in SQL buffer.
SQL> set timing on
SQL> set autotrace traceonly
SQL> select
2 ranid,
dn,
SUM(R008_105) R008_105,
SUM(R008_080) R008_080,
SUM(R008_166) R008_166,
SUM(R008_098) R008_098,
3 4 5 6 7 8 SUM(R007_223) R007_223,
SUM(R008_329) R008_329,
9 10 SUM(R008_014) R008_014,
SUM(R008_165) R008_165,
SUM(R008_097) R008_097,
SUM(R008_181) R008_181,
11 12 13 14 SUM(R008_287) R008_287,
15 SUM(R008_211) R008_211,
16 SUM(R008_210) R008_210,
SUM(R008_036) R008_036,
SUM(R008_130) R008_130,
SUM(R007_225) R007_225,
17 18 19 20 SUM(R008_328) R008_328,
SUM(R008_068) R008_068,
21 22 SUM(R008_182) R008_182,
SUM(R008_212) R008_212,
SUM(R008_035) R008_035,
23 24 25 SUM(R008_109) R008_109,
SUM(R008_051) R008_051,
SUM(R008_327) R008_327,
26 27 28 SUM(R008_069) R008_069,
SUM(R008_155) R008_155,
SUM(R008_326) R008_326,
29 30 31 SUM(R008_021) R008_021,
SUM(R008_348) R008_348,
SUM(R008_316) R008_316,
SUM(R008_214) R008_214,
32 33 34 35 SUM(R008_102) R008_102,
SUM(R008_178) R008_178,
SUM(R008_317) R008_317,
36 37 38 SUM(R008_206) R008_206,
SUM(R008_213) R008_213,
SUM(R008_070) R008_070,
39 40 41 SUM(R008_110) R008_110,
SUM(R008_049) R008_049,
SUM(R008_179) R008_179,
42 43 44 SUM(R008_154) R008_154,
SUM(R008_223) R008_223,
SUM(R008_315) R008_315,
45 46 47 SUM(R008_020) R008_020,
SUM(R008_063) R008_063,
SUM(R008_186) R008_186,
48 49 50 SUM(R008_222) R008_222,
SUM(R008_290) R008_290,
51 52 SUM(R007_224) R007_224,
SUM(R008_015) R008_015,
53 54 SUM(R008_022) R008_022,
SUM(R008_347) R008_347,
SUM(R008_189) R008_189,
55 56 57 SUM(R008_138) R008_138,
SUM(R008_224) R008_224,
58 59 SUM(R008_153) R008_153,
SUM(R008_101) R008_101,
SUM(R008_023) R008_023,
60 61 62 SUM(R008_190) R008_190,
SUM(R008_081) R008_081,
SUM(R008_205) R008_205,
63 64 65 SUM(R008_191) R008_191,
SUM(R008_204) R008_204,
SUM(R008_215) R008_215,
66 67 68 SUM(R008_013) R008_013,
SUM(R008_122) R008_122,
SUM(R008_078) R008_078,
69 70 71 SUM(R008_195) R008_195,
SUM(R008_083) R008_083,
SUM(R008_301) R008_301,
72 73 74 SUM(R008_019) R008_019,
SUM(R008_306) R008_306,
SUM(R008_077) R008_077,
75 76 77 SUM(R008_108) R008_108,
SUM(R008_082) R008_082,
78 79 SUM(R008_029) R008_029,
SUM(R008_216) R008_216,
SUM(R008_193) R008_193,
80 81 82 SUM(R008_137) R008_137,
SUM(R008_028) R008_028,
SUM(R008_107) R008_107,
83 84 85 SUM(R008_324) R008_324,
SUM(R008_085) R008_085,
SUM(R008_121) R008_121,
86 87 88 SUM(R008_106) R008_106,
SUM(R008_192) R008_192,
SUM(R008_323) R008_323,
89 90 91 SUM(R008_041) R008_041,
SUM(R008_325) R008_325,
SUM(R008_194) R008_194,
92 93 94 SUM(R008_318) R008_318,
SUM(R008_303) R008_303,
SUM(R008_040) R008_040,
95 96 97 SUM(R008_111) R008_111,
SUM(R008_073) R008_073,
SUM(R008_304) R008_304,
SUM(R008_169) R008_169,
SUM(R008_174) R008_174,
98 99 100 101 102 SUM(R008_084) R008_084,
SUM(R008_050) R008_050,
103 104 SUM(R008_072) R008_072,
SUM(R008_331) R008_331,
SUM(R007_230) R007_230,
105 106 107 SUM(R008_135) R008_135,
SUM(R008_157) R008_157,
SUM(R008_156) R008_156,
SUM(R008_134) R008_134,
108 109 110 111 SUM(R008_208) R008_208,
SUM(R008_087) R008_087,
SUM(R008_120) R008_120,
112 113 114 SUM(R008_159) R008_159,
SUM(R008_043) R008_043,
SUM(R008_086) R008_086,
115 116 117 SUM(R008_143) R008_143,
118 SUM(R008_330) R008_330,
SUM(R008_042) R008_042,
SUM(R008_207) R008_207,
119 120 121 SUM(R008_144) R008_144,
SUM(R008_308) R008_308,
SUM(R008_088) R008_088,
122 123 124 SUM(R008_059) R008_059,
SUM(R008_071) R008_071,
SUM(R008_044) R008_044,
125 126 127 SUM(R008_302) R008_302,
SUM(R008_141) R008_141,
SUM(R008_209) R008_209,
SUM(R008_001) R008_001,
128 129 130 131 SUM(R008_057) R008_057,
SUM(R008_158) R008_158,
SUM(R008_016) R008_016,
132 133 134 SUM(R008_136) R008_136,
SUM(R008_139) R008_139,
SUM(R008_196) R008_196,
135 136 137 SUM(R008_089) R008_089,
SUM(R008_032) R008_032,
SUM(R008_010) R008_010,
138 139 140 SUM(R008_045) R008_045,
SUM(R007_226) R007_226,
141 142 SUM(R008_033) R008_033,
SUM(R008_026) R008_026,
SUM(R008_127) R008_127,
143 144 145 SUM(R008_177) R008_177,
SUM(R008_034) R008_034,
SUM(R008_092) R008_092,
146 147 148 SUM(R008_339) R008_339,
SUM(R008_171) R008_171,
SUM(R008_176) R008_176,
SUM(R008_031) R008_031,
SUM(R008_170) R008_170,
149 150 151 152 153 SUM(R008_058) R008_058,
SUM(R007_228) R007_228,
SUM(R008_332) R008_332,
SUM(R008_167) R008_167,
154 155 156 157 SUM(R008_123) R008_123,
SUM(R008_116) R008_116,
SUM(R008_172) R008_172,
158 159 160 SUM(R008_168) R008_168,
SUM(R008_025) R008_025,
SUM(R008_096) R008_096,
SUM(R008_079) R008_079,
161 162 163 164 SUM(R008_024) R008_024,
SUM(R008_030) R008_030,
SUM(R008_074) R008_074,
165 166 167 SUM(R008_095) R008_095,
SUM(R008_319) R008_319,
SUM(R008_340) R008_340,
SUM(R008_175) R008_175,
168 169 170 171 SUM(R008_113) R008_113,
SUM(R008_124) R008_124,
SUM(R008_094) R008_094,
SUM(R008_289) R008_289,
172 173 174 175 SUM(R008_067) R008_067,
SUM(R008_173) R008_173,
SUM(R008_004) R008_004,
176 177 178 SUM(R008_199) R008_199,
SUM(R008_018) R008_018,
SUM(R008_307) R008_307,
179 180 181 SUM(R008_140) R008_140,
SUM(R008_112) R008_112,
SUM(R008_065) R008_065,
182 183 184 SUM(R008_115) R008_115,
185 SUM(R008_142) R008_142,
SUM(R008_201) R008_201,
SUM(R008_198) R008_198,
SUM(R008_039) R008_039,
186 187 188 189 SUM(R008_064) R008_064,
SUM(R008_017) R008_017,
SUM(R008_288) R008_288,
190 191 192 SUM(R008_309) R008_309,
SUM(R008_180) R008_180,
193 194 SUM(R008_200) R008_200,
SUM(R008_305) R008_305,
SUM(R008_322) R008_322,
195 196 197 SUM(R008_219) R008_219,
SUM(R008_066) R008_066,
SUM(R008_217) R008_217,
198 199 200 SUM(R008_202) R008_202,
SUM(R008_003) R008_003,
SUM(R008_310) R008_310,
201 202 203 SUM(R008_114) R008_114,
SUM(R008_160) R008_160,
SUM(R008_002) R008_002,
SUM(R008_038) R008_038,
SUM(R008_197) R008_197,
SUM(R008_161) R008_161,
SUM(R008_061) R008_061,
SUM(R008_133) R008_133,
SUM(R008_343) R008_343,
SUM(R008_203) R008_203,
SUM(R008_162) R008_162,
SUM(R008_060) R008_060,
SUM(R008_119) R008_119,
SUM(R008_151) R008_151,
SUM(R008_007) R008_007,
SUM(R008_149) R008_149,
SUM(R008_076) R008_076,
SUM(R008_118) R008_118,
SUM(R008_006) R008_006,
SUM(R008_075) R008_075,
SUM(R008_053) R008_053,
SUM(R008_132) R008_132,
SUM(R008_027) R008_027,
SUM(R008_128) R008_128,
SUM(R008_334) R008_334,
SUM(R008_344) R008_344,
SUM(R008_093) R008_093,
SUM(R008_150) R008_150,
SUM(R008_333) R008_333,
SUM(R008_008) R008_008,
SUM(R008_221) R008_221,
204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 SUM(R008_313) R008_313,
SUM(R008_148) R008_148,
235 236 SUM(R008_314) R008_314,
SUM(R008_126) R008_126,
SUM(R008_131) R008_131,
SUM(R008_104) R008_104,
237 238 239 240 SUM(R008_054) R008_054,
SUM(R008_335) R008_335,
SUM(R008_163) R008_163,
241 242 243 SUM(R008_125) R008_125,
SUM(R008_009) R008_009,
244 245 SUM(R008_147) R008_147,
SUM(R008_062) R008_062,
SUM(R008_052) R008_052,
246 247 248 SUM(R008_103) R008_103,
SUM(R008_117) R008_117,
SUM(R008_056) R008_056,
249 250 251 SUM(R008_146) R008_146,
SUM(R008_184) R008_184,
SUM(R008_090) R008_090,
252 253 254 SUM(R007_229) R007_229,
SUM(R008_099) R008_099,
SUM(R008_048) R008_048,
255 256 257 SUM(R008_341) R008_341,
SUM(R008_337) R008_337,
258 259 SUM(R008_183) R008_183,
SUM(R008_220) R008_220,
260 261 SUM(R008_336) R008_336,
262 SUM(R008_055) R008_055,
263 SUM(R008_011) R008_011,
SUM(R008_188) R008_188,
SUM(R008_342) R008_342,
264 265 266 SUM(R008_320) R008_320,
SUM(R008_012) R008_012,
267 268 SUM(R007_227) R007_227,
SUM(R008_187) R008_187,
SUM(R008_129) R008_129,
SUM(R008_346) R008_346,
SUM(R008_100) R008_100,
SUM(R008_005) R008_005,
SUM(R008_345) R008_345,
SUM(R008_164) R008_164,
SUM(R008_037) R008_037,
269 270 271 272 273 274 275 276 277 SUM(R008_312) R008_312,
SUM(R008_145) R008_145,
SUM(R008_091) R008_091,
SUM(R008_152) R008_152,
278 279 280 281 SUM(R008_046) R008_046,
SUM(R008_321) R008_321,
SUM(R008_311) R008_311,
282 283 284 SUM(R008_338) R008_338,
SUM(R008_218) R008_218,
SUM(R008_047) R008_047,
285 286 287 SUM(R008_185) R008_185
from PDATA_CELL_3 a
where end_time >=
288 289 290 to_date('2012-04-14 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and
291 end_time <=
to_date('2012-04-15 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and
begin_time >=
292 293 294 to_date('2012-04-14 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
and a.ranid in (940, 942, 947, 2378, 944, 943, 941)
group by ranid, dn;
295 296
1408 rows selected.
Elapsed: 00:33:58.47
Execution Plan
----------------------------------------------------------
Plan hash value: 1780662790
--------------------------------------------------------------------------------
------------------------------------------
| Id | Operation | Name | Rows | Bytes
| Cost (%CPU)| Time | Pstart| Pstop |
--------------------------------------------------------------------------------
------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 660
| 4 (25)| 00:00:01 | | |
| 1 | HASH GROUP BY | | 1 | 660
| 4 (25)| 00:00:01 | | |
| 2 | PARTITION RANGE ITERATOR | | 1 | 660
| 3 (0)| 00:00:01 | 86 | 87 |
| 3 | TABLE ACCESS BY LOCAL INDEX ROWID| PDATA_CELL_3 | 1 | 660
| 3 (0)| 00:00:01 | 86 | 87 |
|* 4 | INDEX RANGE SCAN | PDATA_CELL_3_INDEX | 1 |
| 2 (0)| 00:00:01 | 86 | 87 |
--------------------------------------------------------------------------------
------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
4 - access("END_TIME">=TO_DATE('2012-04-14 00:00:00', 'yyyy-mm-dd hh24:mi:ss'
) AND
"BEGIN_TIME">=TO_DATE('2012-04-14 00:00:00', 'yyyy-mm-dd hh24:mi:s
s') AND "END_TIME"<=TO_DATE('2012-04-15
00:00:00', 'yyyy-mm-dd hh24:mi:ss'))
filter("BEGIN_TIME">=TO_DATE('2012-04-14 00:00:00', 'yyyy-mm-dd hh24:mi:s
s') AND
(TO_NUMBER("A"."RANID")=940 OR TO_NUMBER("A"."RANID")=947 OR TO_NU
MBER("A"."RANID")=941 OR
TO_NUMBER("A"."RANID")=944 OR TO_NUMBER("A"."RANID")=943 OR TO_NUM
BER("A"."RANID")=942 OR
TO_NUMBER("A"."RANID")=2378))
Statistics
----------------------------------------------------------
984 recursive calls
0 db block gets
424968 consistent gets
38995 physical reads
0 redo size
199556 bytes sent via SQL*Net to client
7311 bytes received via SQL*Net from client
95 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1408 rows processed
SQL> SQL> SQL> select /*+ INDEX(a PDATA_CELL_3_INDEX) */
2 ranid,
dn,
SUM(R008_105) R008_105,
SUM(R008_080) R008_080,
SUM(R008_166) R008_166,
SUM(R008_098) R008_098,
SUM(R007_223) R007_223,
SUM(R008_329) R008_329,
3 4 5 6 7 8 9 10 SUM(R008_014) R008_014,
SUM(R008_165) R008_165,
SUM(R008_097) R008_097,
11 12 13 SUM(R008_181) R008_181,
14 SUM(R008_287) R008_287,
SUM(R008_211) R008_211,
15 16 SUM(R008_210) R008_210,
17 SUM(R008_036) R008_036,
18 SUM(R008_130) R008_130,
19 SUM(R007_225) R007_225,
20 SUM(R008_328) R008_328,
21 SUM(R008_068) R008_068,
22 SUM(R008_182) R008_182,
23 SUM(R008_212) R008_212,
24 SUM(R008_035) R008_035,
25 SUM(R008_109) R008_109,
26 SUM(R008_051) R008_051,
27 SUM(R008_327) R008_327,
28 SUM(R008_069) R008_069,
SUM(R008_155) R008_155,
SUM(R008_326) R008_326,
SUM(R008_021) R008_021,
SUM(R008_348) R008_348,
29 30 31 32 33 SUM(R008_316) R008_316,
SUM(R008_214) R008_214,
SUM(R008_102) R008_102,
SUM(R008_178) R008_178,
34 35 36 37 SUM(R008_317) R008_317,
38 SUM(R008_206) R008_206,
39 SUM(R008_213) R008_213,
SUM(R008_070) R008_070,
SUM(R008_110) R008_110,
SUM(R008_049) R008_049,
40 41 42 43 SUM(R008_179) R008_179,
SUM(R008_154) R008_154,
44 45 SUM(R008_223) R008_223,
SUM(R008_315) R008_315,
SUM(R008_020) R008_020,
46 47 48 SUM(R008_063) R008_063,
49 SUM(R008_186) R008_186,
50 SUM(R008_222) R008_222,
51 SUM(R008_290) R008_290,
52 SUM(R007_224) R007_224,
53 SUM(R008_015) R008_015,
54 SUM(R008_022) R008_022,
SUM(R008_347) R008_347,
55 56 SUM(R008_189) R008_189,
57 SUM(R008_138) R008_138,
SUM(R008_224) R008_224,
SUM(R008_153) R008_153,
58 59 60 SUM(R008_101) R008_101,
61 SUM(R008_023) R008_023,
SUM(R008_190) R008_190,
SUM(R008_081) R008_081,
SUM(R008_205) R008_205,
SUM(R008_191) R008_191,
SUM(R008_204) R008_204,
SUM(R008_215) R008_215,
SUM(R008_013) R008_013,
SUM(R008_122) R008_122,
SUM(R008_078) R008_078,
SUM(R008_195) R008_195,
SUM(R008_083) R008_083,
SUM(R008_301) R008_301,
SUM(R008_019) R008_019,
62 63 64 65 66 67 68 69 70 71 72 SUM(R008_306) R008_306,
73 74 75 76 SUM(R008_077) R008_077,
SUM(R008_108) R008_108,
SUM(R008_082) R008_082,
77 78 79 SUM(R008_029) R008_029,
SUM(R008_216) R008_216,
SUM(R008_193) R008_193,
SUM(R008_137) R008_137,
SUM(R008_028) R008_028,
SUM(R008_107) R008_107,
80 81 82 83 84 85 SUM(R008_324) R008_324,
86 SUM(R008_085) R008_085,
87 SUM(R008_121) R008_121,
SUM(R008_106) R008_106,
SUM(R008_192) R008_192,
88 89 90 SUM(R008_323) R008_323,
91 SUM(R008_041) R008_041,
92 SUM(R008_325) R008_325,
93 SUM(R008_194) R008_194,
94 SUM(R008_318) R008_318,
SUM(R008_303) R008_303,
SUM(R008_040) R008_040,
SUM(R008_111) R008_111,
SUM(R008_073) R008_073,
SUM(R008_304) R008_304,
SUM(R008_169) R008_169,
SUM(R008_174) R008_174,
SUM(R008_084) R008_084,
SUM(R008_050) R008_050,
SUM(R008_072) R008_072,
SUM(R008_331) R008_331,
95 96 97 98 99 100 101 102 103 104 105 106 SUM(R007_230) R007_230,
107 SUM(R008_135) R008_135,
108 SUM(R008_157) R008_157,
109 SUM(R008_156) R008_156,
110 SUM(R008_134) R008_134,
111 SUM(R008_208) R008_208,
112 SUM(R008_087) R008_087,
113 SUM(R008_120) R008_120,
114 SUM(R008_159) R008_159,
SUM(R008_043) R008_043,
115 116 SUM(R008_086) R008_086,
117 SUM(R008_143) R008_143,
SUM(R008_330) R008_330,
118 119 SUM(R008_042) R008_042,
120 SUM(R008_207) R008_207,
SUM(R008_144) R008_144,
SUM(R008_308) R008_308,
121 122 123 SUM(R008_088) R008_088,
124 SUM(R008_059) R008_059,
125 SUM(R008_071) R008_071,
126 SUM(R008_044) R008_044,
127 SUM(R008_302) R008_302,
128 SUM(R008_141) R008_141,
SUM(R008_209) R008_209,
129 130 SUM(R008_001) R008_001,
131 SUM(R008_057) R008_057,
SUM(R008_158) R008_158,
132 133 SUM(R008_016) R008_016,
134 SUM(R008_136) R008_136,
SUM(R008_139) R008_139,
SUM(R008_196) R008_196,
135 136 137 SUM(R008_089) R008_089,
138 SUM(R008_032) R008_032,
139 SUM(R008_010) R008_010,
140 SUM(R008_045) R008_045,
141 SUM(R007_226) R007_226,
142 SUM(R008_033) R008_033,
143 SUM(R008_026) R008_026,
SUM(R008_127) R008_127,
144 145 SUM(R008_177) R008_177,
SUM(R008_034) R008_034,
SUM(R008_092) R008_092,
SUM(R008_339) R008_339,
SUM(R008_171) R008_171,
SUM(R008_176) R008_176,
SUM(R008_031) R008_031,
SUM(R008_170) R008_170,
SUM(R008_058) R008_058,
SUM(R007_228) R007_228,
146 147 148 149 150 151 152 153 154 155 SUM(R008_332) R008_332,
156 SUM(R008_167) R008_167,
157 SUM(R008_123) R008_123,
158 SUM(R008_116) R008_116,
SUM(R008_172) R008_172,
SUM(R008_168) R008_168,
SUM(R008_025) R008_025,
159 160 161 162 SUM(R008_096) R008_096,
163 SUM(R008_079) R008_079,
SUM(R008_024) R008_024,
SUM(R008_030) R008_030,
SUM(R008_074) R008_074,
SUM(R008_095) R008_095,
SUM(R008_319) R008_319,
SUM(R008_340) R008_340,
SUM(R008_175) R008_175,
SUM(R008_113) R008_113,
SUM(R008_124) R008_124,
SUM(R008_094) R008_094,
164 165 166 167 168 169 170 171 172 173 174 SUM(R008_289) R008_289,
SUM(R008_067) R008_067,
SUM(R008_173) R008_173,
SUM(R008_004) R008_004,
SUM(R008_199) R008_199,
SUM(R008_018) R008_018,
SUM(R008_307) R008_307,
SUM(R008_140) R008_140,
SUM(R008_112) R008_112,
SUM(R008_065) R008_065,
SUM(R008_115) R008_115,
SUM(R008_142) R008_142,
SUM(R008_201) R008_201,
SUM(R008_198) R008_198,
175 176 177 178 179 180 181 182 183 184 185 186 187 188 SUM(R008_039) R008_039,
SUM(R008_064) R008_064,
SUM(R008_017) R008_017,
SUM(R008_288) R008_288,
SUM(R008_309) R008_309,
189 190 191 192 193 SUM(R008_180) R008_180,
SUM(R008_200) R008_200,
SUM(R008_305) R008_305,
SUM(R008_322) R008_322,
SUM(R008_219) R008_219,
SUM(R008_066) R008_066,
SUM(R008_217) R008_217,
194 195 196 197 198 199 200 SUM(R008_202) R008_202,
SUM(R008_003) R008_003,
SUM(R008_310) R008_310,
201 202 203 SUM(R008_114) R008_114,
204 SUM(R008_160) R008_160,
SUM(R008_002) R008_002,
SUM(R008_038) R008_038,
SUM(R008_197) R008_197,
SUM(R008_161) R008_161,
SUM(R008_061) R008_061,
SUM(R008_133) R008_133,
205 206 207 208 209 210 211 SUM(R008_343) R008_343,
SUM(R008_203) R008_203,
SUM(R008_162) R008_162,
SUM(R008_060) R008_060,
212 213 214 215 SUM(R008_119) R008_119,
SUM(R008_151) R008_151,
SUM(R008_007) R008_007,
216 217 218 SUM(R008_149) R008_149,
219 SUM(R008_076) R008_076,
SUM(R008_118) R008_118,
SUM(R008_006) R008_006,
220 221 222 SUM(R008_075) R008_075,
SUM(R008_053) R008_053,
SUM(R008_132) R008_132,
223 224 225 SUM(R008_027) R008_027,
226 SUM(R008_128) R008_128,
227 SUM(R008_334) R008_334,
228 SUM(R008_344) R008_344,
229 SUM(R008_093) R008_093,
SUM(R008_150) R008_150,
SUM(R008_333) R008_333,
230 231 232 SUM(R008_008) R008_008,
SUM(R008_221) R008_221,
SUM(R008_313) R008_313,
SUM(R008_148) R008_148,
233 234 235 236 SUM(R008_314) R008_314,
237 SUM(R008_126) R008_126,
238 SUM(R008_131) R008_131,
239 SUM(R008_104) R008_104,
240 SUM(R008_054) R008_054,
241 SUM(R008_335) R008_335,
SUM(R008_163) R008_163,
242 243 SUM(R008_125) R008_125,
SUM(R008_009) R008_009,
SUM(R008_147) R008_147,
SUM(R008_062) R008_062,
SUM(R008_052) R008_052,
244 245 246 247 248 SUM(R008_103) R008_103,
249 SUM(R008_117) R008_117,
250 SUM(R008_056) R008_056,
251 SUM(R008_146) R008_146,
SUM(R008_184) R008_184,
SUM(R008_090) R008_090,
SUM(R007_229) R007_229,
252 253 254 255 SUM(R008_099) R008_099,
SUM(R008_048) R008_048,
SUM(R008_341) R008_341,
SUM(R008_337) R008_337,
SUM(R008_183) R008_183,
SUM(R008_220) R008_220,
SUM(R008_336) R008_336,
SUM(R008_055) R008_055,
SUM(R008_011) R008_011,
SUM(R008_188) R008_188,
SUM(R008_342) R008_342,
SUM(R008_320) R008_320,
SUM(R008_012) R008_012,
SUM(R007_227) R007_227,
SUM(R008_187) R008_187,
SUM(R008_129) R008_129,
SUM(R008_346) R008_346,
SUM(R008_100) R008_100,
SUM(R008_005) R008_005,
SUM(R008_345) R008_345,
SUM(R008_164) R008_164,
SUM(R008_037) R008_037,
SUM(R008_312) R008_312,
SUM(R008_145) R008_145,
SUM(R008_091) R008_091,
SUM(R008_152) R008_152,
SUM(R008_046) R008_046,
SUM(R008_321) R008_321,
SUM(R008_311) R008_311,
SUM(R008_338) R008_338,
SUM(R008_218) R008_218,
SUM(R008_047) R008_047,
SUM(R008_185) R008_185
from PDATA_CELL_3 a
where end_time >=
to_date('2012-04-14 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and
end_time <=
to_date('2012-04-15 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and
begin_time >=
to_date('2012-04-14 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
and a.ranid in (940, 942, 947, 2378, 944, 943, 941)
group by ranid, dn;
256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296
1408 rows selected.
Elapsed: 00:24:33.72
Execution Plan
----------------------------------------------------------
Plan hash value: 1780662790
--------------------------------------------------------------------------------
------------------------------------------
| Id | Operation | Name | Rows | Bytes
| Cost (%CPU)| Time | Pstart| Pstop |
--------------------------------------------------------------------------------
------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 660
| 4 (25)| 00:00:01 | | |
| 1 | HASH GROUP BY | | 1 | 660
| 4 (25)| 00:00:01 | | |
| 2 | PARTITION RANGE ITERATOR | | 1 | 660
| 3 (0)| 00:00:01 | 86 | 87 |
| 3 | TABLE ACCESS BY LOCAL INDEX ROWID| PDATA_CELL_3 | 1 | 660
| 3 (0)| 00:00:01 | 86 | 87 |
|* 4 | INDEX RANGE SCAN | PDATA_CELL_3_INDEX | 1 |
| 2 (0)| 00:00:01 | 86 | 87 |
--------------------------------------------------------------------------------
------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
4 - access("END_TIME">=TO_DATE('2012-04-14 00:00:00', 'yyyy-mm-dd hh24:mi:ss'
) AND
"BEGIN_TIME">=TO_DATE('2012-04-14 00:00:00', 'yyyy-mm-dd hh24:mi:s
s') AND "END_TIME"<=TO_DATE('2012-04-15
00:00:00', 'yyyy-mm-dd hh24:mi:ss'))
filter("BEGIN_TIME">=TO_DATE('2012-04-14 00:00:00', 'yyyy-mm-dd hh24:mi:s
s') AND
(TO_NUMBER("A"."RANID")=940 OR TO_NUMBER("A"."RANID")=947 OR TO_NU
MBER("A"."RANID")=941 OR
TO_NUMBER("A"."RANID")=944 OR TO_NUMBER("A"."RANID")=943 OR TO_NUM
BER("A"."RANID")=942 OR
TO_NUMBER("A"."RANID")=2378))
Statistics
----------------------------------------------------------
984 recursive calls
0 db block gets
424962 consistent gets
29499 physical reads
0 redo size
199556 bytes sent via SQL*Net to client
7347 bytes received via SQL*Net from client
95 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1408 rows processed
SQL> SQL>
1504
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
