Re: 11g query taking 24 seconds, same query was instant in 9i.
Date: Wed, 26 May 2010 16:25:42 GMT
Message-ID: <aYbLn.5022$z%6.1233_at_edtnps83>
gs wrote:
> Users of the app for the database I recently updated are saying some > reports are taking an unusually long time to run now, up to 1/2 a minute > whereas it was almost instant before the upgrade. > > I managed to find a sample of the sql that runs for the report, and ran > it from command line SQL and the 9i was running around .7 seconds while > the 11g was in the 24 second range. They also report that the 11g is > also not sorting the report like it was being sorted in 9i. > > I haven't had as much time as I want to spend with tuning, but from > reading the explain plans I can see that it looks like there is quite a > difference here in how the two databases handle the query. I'm wading > through technet etc. trying to decipher this but maybe another set of > eyes can point out something that I'm missing here. > > The SQL: > ========================================================================>> GROUP BY trunc(SAMPLE_DATE)
>> SELECT TRUNC(sample_date) as samp_date,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '0000', sample_value)) samp1,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '0100', sample_value)) samp2,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '0200', sample_value)) samp3,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '0300', sample_value)) samp4,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '0400', sample_value)) samp5,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '0500', sample_value)) samp6,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '0600', sample_value)) samp7,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '0700', sample_value)) samp8,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '0800', sample_value)) samp9,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '0900', sample_value)) samp10,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '1000', sample_value)) samp11,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '1100', sample_value)) samp12,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '1200', sample_value)) samp13,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '1300', sample_value)) samp14,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '1400', sample_value)) samp15,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '1500', sample_value)) samp16,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '1600', sample_value)) samp17,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '1700', sample_value)) samp18,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '1800', sample_value)) samp19,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '1900', sample_value)) samp20,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '2000', sample_value)) samp21,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '2100', sample_value)) samp22,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '2200', sample_value)) samp23,
>>
>> SUM(decode(to_char(sample_date,'HH24MI'), '2300', sample_value)) samp24,
>> avg(sample_value) avg_value,
>> max(a.sample_avg) s_avg, max(a.sample_stddev) s_stddev,
>> max(a.cv_pct) s_cv
>> FROM vw_cem_corr, (SELECT
>> Avg(sample_value) sample_avg,
>> Stddev(sample_value) sample_stddev,
>> stddev(sample_value)/avg(sample_value)*100 CV_PCT
>> FROM vw_cem_corr
>> WHERE (sample_date >= '01-apr-09') and
>> (TRUNC(sample_date) <= '30-apr-09')
>> and (mill_area = 'KLN')
>> and (tagname = 'FLOWDRY')) a
>> WHERE (sample_date >= '01-apr-09') and
>> (TRUNC(sample_date) <= '30-apr-09')
>> and (mill_area = 'KLN')
>> and (tagname = 'FLOWDRY')
>> /
> > > ================================================================================
pls excuse the formatting, my newsreader for some reason posted that as quotes, I'll try a plain paste:
9i explain plan:
SQL> SELECT * FROM TABLE(dbms_xplan.display);
| Id | Operation | Name| Rows | Bytes | Cost |
| 0 | SELECT STATEMENT | | 10 | 760 | 172 | | 1 | SORT GROUP BY | | 10 | 760 | 172 | | 2 | MERGE JOIN CARTESIAN | | 10 | 760 | 170 | | 3 | VIEW | | 1 | 39 | 87 | | 4 | SORT AGGREGATE | | 1 | 37 | | | 5 | VIEW | VW_CEM_CORR | 10 | 370 | 87 | | 6 | SORT UNIQUE | | 10 | 710 | 90 | | 7 | UNION-ALL | | | | | |* 8 | FILTER | | | | | | 9 | NESTED LOOPS | | 1 | 71 | 7 | | 10 | NESTED LOOPS | | 1 | 47 | 5 | | 11 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |* 12 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 13 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |* 14 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 15 | SORT AGGREGATE | | 1 | 13 | | | 16 | FIRST ROW | | 1 | 13 | 1 | |* 17 | INDEX RANGE SCAN (MIN/MAX)| PK_DWQSTATIONSTATUS | 187 | | 1 | | 18 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |* 19 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |* 20 | FILTER | | | | | | 21 | NESTED LOOPS | | 1 | 71 | 7 | | 22 | NESTED LOOPS | | 1 | 47 | 5 | | 23 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |* 24 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 25 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |* 26 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 27 | SORT AGGREGATE | | 1 | 13 | | | 28 | FIRST ROW | | 1 | 13 | 1 | |* 29 | INDEX RANGE SCAN (MIN/MAX)| PK_DWQSTATIONSTATUS | 187 | | 1 | | 30 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |* 31 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |* 32 | FILTER | | | | | | 33 | NESTED LOOPS | | 1 | 71 | 7 | | 34 | NESTED LOOPS | | 1 | 47 | 5 | | 35 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |* 36 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 37 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |* 38 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 39 | SORT AGGREGATE | | 1 | 13 | | | 40 | FIRST ROW | | 1 | 13 | 1 | |* 41 | INDEX RANGE SCAN (MIN/MAX)| PK_DWQSTATIONSTATUS | 187 | | 1 | | 42 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |* 43 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |* 44 | FILTER | | | | | | 45 | NESTED LOOPS | | 1 | 71 | 7 | | 46 | NESTED LOOPS | | 1 | 47 | 5 | | 47 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |* 48 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 49 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |* 50 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 51 | SORT AGGREGATE | | 1 | 13 | | | 52 | FIRST ROW | | 1 | 13 | 1 | |* 53 | INDEX RANGE SCAN (MIN/MAX)| PK_DWQSTATIONSTATUS | 187 | | 1 | | 54 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |* 55 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |* 56 | FILTER | | | | | | 57 | NESTED LOOPS | | 1 | 71 | 7 | | 58 | NESTED LOOPS | | 1 | 47 | 5 | | 59 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |* 60 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 61 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |* 62 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 63 | SORT AGGREGATE | | 1 | 13 | | | 64 | FIRST ROW | | 1 | 13 | 1 | |* 65 | INDEX RANGE SCAN (MIN/MAX)| PK_DWQSTATIONSTATUS | 187 | | 1 | | 66 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |* 67 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |* 68 | FILTER | | | | | | 69 | NESTED LOOPS | | 1 | 71 | 7 | | 70 | NESTED LOOPS | | 1 | 47 | 5 | | 71 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |* 72 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 73 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |* 74 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 75 | SORT AGGREGATE | | 1 | 13 | | | 76 | FIRST ROW | | 1 | 13 | 1 | |* 77 | INDEX RANGE SCAN (MIN/MAX)| PK_DWQSTATIONSTATUS | 187 | | 1 | | 78 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |* 79 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | | 80 | NESTED LOOPS | | 1 | 71 | 7 | | 81 | NESTED LOOPS | | 1 | 47 | 5 | | 82 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |* 83 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 84 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |* 85 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 86 | SORT AGGREGATE | | 1 | 13 | | | 87 | FIRST ROW | | 1 | 13 | 1 | |* 88 | INDEX RANGE SCAN (MIN/MAX) | PK_DWQSTATIONSTATUS | 187 | | 1 | | 89 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |* 90 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |* 91 | FILTER | | | | | | 92 | NESTED LOOPS | | 1 | 71 | 7 | | 93 | NESTED LOOPS | | 1 | 47 | 5 | | 94 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |* 95 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 96 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |* 97 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 98 | SORT AGGREGATE | | 1 | 13 | | | 99 | FIRST ROW | | 1 | 13 | 1 | |*100 | INDEX RANGE SCAN (MIN/MAX)| PK_DWQSTATIONSTATUS | 187 | | 1 | | 101 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |*102 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |*103 | FILTER | | | | | | 104 | NESTED LOOPS | | 1 | 71 | 7 | | 105 | NESTED LOOPS | | 1 | 47 | 5 | | 106 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |*107 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 108 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |*109 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 110 | SORT AGGREGATE | | 1 | 13 | | | 111 | FIRST ROW | | 1 | 13 | 1 | |*112 | INDEX RANGE SCAN (MIN/MAX)| PK_DWQSTATIONSTATUS | 187 | | 1 | | 113 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |*114 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |*115 | FILTER | | | | | | 116 | NESTED LOOPS | | 1 | 71 | 7 | | 117 | NESTED LOOPS | | 1 | 47 | 5 | | 118 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |*119 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 120 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |*121 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 122 | SORT AGGREGATE | | 1 | 13 | | | 123 | FIRST ROW | | 1 | 13 | 1 | |*124 | INDEX RANGE SCAN (MIN/MAX)| PK_DWQSTATIONSTATUS | 187 | | 1 | | 125 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |*126 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | | 127 | VIEW | VW_CEM_CORR | 10 | 370 | 85 | | 128 | SORT UNIQUE | | 10 | 710 | 90 | | 129 | UNION-ALL | | | | | |*130 | FILTER | | | | | | 131 | NESTED LOOPS | | 1 | 71 | 7 | | 132 | NESTED LOOPS | | 1 | 47 | 5 | | 133 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |*134 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 135 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |*136 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 137 | SORT AGGREGATE | | 1 | 13 | | | 138 | FIRST ROW | | 1 | 13 | 1 | |*139 | INDEX RANGE SCAN (MIN/MAX) | PK_DWQSTATIONSTATUS | 187 | | 1 | | 140 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |*141 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |*142 | FILTER | | | | | | 143 | NESTED LOOPS | | 1 | 71 | 7 | | 144 | NESTED LOOPS | | 1 | 47 | 5 | | 145 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |*146 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 147 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |*148 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 149 | SORT AGGREGATE | | 1 | 13 | | | 150 | FIRST ROW | | 1 | 13 | 1 | |*151 | INDEX RANGE SCAN (MIN/MAX) | PK_DWQSTATIONSTATUS | 187 | | 1 | | 152 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |*153 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |*154 | FILTER | | | | | | 155 | NESTED LOOPS | | 1 | 71 | 7 | | 156 | NESTED LOOPS | | 1 | 47 | 5 | | 157 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |*158 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 159 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |*160 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 161 | SORT AGGREGATE | | 1 | 13 | | | 162 | FIRST ROW | | 1 | 13 | 1 | |*163 | INDEX RANGE SCAN (MIN/MAX) | PK_DWQSTATIONSTATUS | 187 | | 1 | | 164 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |*165 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |*166 | FILTER | | | | | | 167 | NESTED LOOPS | | 1 | 71 | 7 | | 168 | NESTED LOOPS | | 1 | 47 | 5 | | 169 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |*170 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 171 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |*172 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 173 | SORT AGGREGATE | | 1 | 13 | | | 174 | FIRST ROW | | 1 | 13 | 1 | |*175 | INDEX RANGE SCAN (MIN/MAX) | PK_DWQSTATIONSTATUS | 187 | | 1 | | 176 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |*177 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |*178 | FILTER | | | | | | 179 | NESTED LOOPS | | 1 | 71 | 7 | | 180 | NESTED LOOPS | | 1 | 47 | 5 | | 181 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |*182 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 183 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |*184 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 185 | SORT AGGREGATE | | 1 | 13 | | | 186 | FIRST ROW | | 1 | 13 | 1 | |*187 | INDEX RANGE SCAN (MIN/MAX) | PK_DWQSTATIONSTATUS | 187 | | 1 | | 188 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |*189 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |*190 | FILTER | | | | | | 191 | NESTED LOOPS | | 1 | 71 | 7 | | 192 | NESTED LOOPS | | 1 | 47 | 5 | | 193 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |*194 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 195 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |*196 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 197 | SORT AGGREGATE | | 1 | 13 | | | 198 | FIRST ROW | | 1 | 13 | 1 | |*199 | INDEX RANGE SCAN (MIN/MAX) | PK_DWQSTATIONSTATUS | 187 | | 1 | | 200 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |*201 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | | 202 | NESTED LOOPS | | 1 | 71 | 7 | | 203 | NESTED LOOPS | | 1 | 47 | 5 | | 204 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |*205 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 206 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |*207 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 208 | SORT AGGREGATE | | 1 | 13 | | | 209 | FIRST ROW | | 1 | 13 | 1 | |*210 | INDEX RANGE SCAN (MIN/MAX) | PK_DWQSTATIONSTATUS | 187 | | 1 | | 211 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |*212 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |*213 | FILTER | | | | | | 214 | NESTED LOOPS | | 1 | 71 | 7 | | 215 | NESTED LOOPS | | 1 | 47 | 5 | | 216 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |*217 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 218 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |*219 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 220 | SORT AGGREGATE | | 1 | 13 | | | 221 | FIRST ROW | | 1 | 13 | 1 | |*222 | INDEX RANGE SCAN (MIN/MAX) | PK_DWQSTATIONSTATUS | 187 | | 1 | | 223 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |*224 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |*225 | FILTER | | | | | | 226 | NESTED LOOPS | | 1 | 71 | 7 | | 227 | NESTED LOOPS | | 1 | 47 | 5 | | 228 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |*229 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 230 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |*231 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 232 | SORT AGGREGATE | | 1 | 13 | | | 233 | FIRST ROW | | 1 | 13 | 1 | |*234 | INDEX RANGE SCAN (MIN/MAX) | PK_DWQSTATIONSTATUS | 187 | | 1 | | 235 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |*236 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | |*237 | FILTER | | | | | | 238 | NESTED LOOPS | | 1 | 71 | 7 | | 239 | NESTED LOOPS | | 1 | 47 | 5 | | 240 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 4 | |*241 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 1 | | 3 | | 242 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 1 | 17 | 1 | |*243 | INDEX UNIQUE SCAN | PK_DWQSTATIONSTATUS | 1 | | | | 244 | SORT AGGREGATE | | 1 | 13 | | | 245 | FIRST ROW | | 1 | 13 | 1 | |*246 | INDEX RANGE SCAN (MIN/MAX) | PK_DWQSTATIONSTATUS | 187 | | 1 | | 247 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 24 | 2 | |*248 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 | -------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
8 - filter('TRSC12HR'='FLOWDRY')
12 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='TRSC12HR') filter("SYS_ALIAS_2"."TAGNAME"='TRSC12HR' AND
TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
14 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 17 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
19 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='TRSC12V') filter("B"."SAMPLE_DATE">='01-apr-09')
20 - filter('TRSM12HR'='FLOWDRY')
24 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='TRSM12HR') filter("SYS_ALIAS_2"."TAGNAME"='TRSM12HR' AND
TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
26 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 29 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
31 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='TRSM12V') filter("B"."SAMPLE_DATE">='01-apr-09')
32 - filter('SO2M12HR'='FLOWDRY')
36 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='SO2M12HR') filter("SYS_ALIAS_2"."TAGNAME"='SO2M12HR' AND
TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
38 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 41 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
43 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='SO2M12V') filter("B"."SAMPLE_DATE">='01-apr-09')
44 - filter('SO2COMP'='FLOWDRY')
48 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='SO2COMP') filter("SYS_ALIAS_2"."TAGNAME"='SO2COMP' AND
TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
50 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 53 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
55 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='SO2C12V') filter("B"."SAMPLE_DATE">='01-apr-09')
56 - filter('O2'='FLOWDRY')
60 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='O2') filter("SYS_ALIAS_2"."TAGNAME"='O2' AND TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
62 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 65 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
67 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='O2V') filter("B"."SAMPLE_DATE">='01-apr-09')
68 - filter('CO'='FLOWDRY')
72 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='CO') filter("SYS_ALIAS_2"."TAGNAME"='CO' AND TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
74 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 77 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
79 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='COV') filter("B"."SAMPLE_DATE">='01-apr-09')
83 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='FLOWDRY') filter("SYS_ALIAS_2"."TAGNAME"='FLOWDRY' AND
TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
85 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 88 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
90 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='FLOWV') filter("B"."SAMPLE_DATE">='01-apr-09')
91 - filter('OPACMB1H'='FLOWDRY' AND 'OPAC1H'='FLOWDRY')
95 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09')
filter(TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
97 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 100 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
102 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='OPACV') filter("B"."SAMPLE_DATE">='01-apr-09')
103 - filter('TEMP'='FLOWDRY')
107 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='TEMP') filter("SYS_ALIAS_2"."TAGNAME"='TEMP' AND TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
109 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 112 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
114 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='TEMPV') filter("B"."SAMPLE_DATE">='01-apr-09')
115 - filter('OPACMB6M'='FLOWDRY' AND 'OPAC6M'='FLOWDRY')
119 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09')
filter(TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
121 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 124 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
126 - access("B"."MILL_AREA"='KLN' AND "B"."SAMPLE_DATE"=TRUNC("SYS_ALIAS_2"."SAMPLE_DATE",'fmhh
') AND "B"."TAGNAME"='OPACV') 130 - filter('TRSC12HR'='FLOWDRY')
134 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='TRSC12HR') filter("SYS_ALIAS_2"."TAGNAME"='TRSC12HR' AND
TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
136 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 139 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
141 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='TRSC12V') filter("B"."SAMPLE_DATE">='01-apr-09')
142 - filter('TRSM12HR'='FLOWDRY')
146 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='TRSM12HR') filter("SYS_ALIAS_2"."TAGNAME"='TRSM12HR' AND
TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
148 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 151 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
153 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='TRSM12V') filter("B"."SAMPLE_DATE">='01-apr-09')
154 - filter('SO2M12HR'='FLOWDRY')
158 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='SO2M12HR') filter("SYS_ALIAS_2"."TAGNAME"='SO2M12HR' AND
TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
160 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 163 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
165 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='SO2M12V') filter("B"."SAMPLE_DATE">='01-apr-09')
166 - filter('SO2COMP'='FLOWDRY')
170 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='SO2COMP') filter("SYS_ALIAS_2"."TAGNAME"='SO2COMP' AND
TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
172 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 175 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
177 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='SO2C12V') filter("B"."SAMPLE_DATE">='01-apr-09')
178 - filter('O2'='FLOWDRY')
182 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='O2') filter("SYS_ALIAS_2"."TAGNAME"='O2' AND TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
184 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 187 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
189 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='O2V') filter("B"."SAMPLE_DATE">='01-apr-09')
190 - filter('CO'='FLOWDRY')
194 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='CO') filter("SYS_ALIAS_2"."TAGNAME"='CO' AND TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
196 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 199 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
201 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='COV') filter("B"."SAMPLE_DATE">='01-apr-09')
205 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='FLOWDRY') filter("SYS_ALIAS_2"."TAGNAME"='FLOWDRY' AND
TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
207 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 210 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
212 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='FLOWV') filter("B"."SAMPLE_DATE">='01-apr-09')
213 - filter('OPACMB1H'='FLOWDRY' AND 'OPAC1H'='FLOWDRY')
217 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09')
filter(TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
219 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 222 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
224 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='OPACV') filter("B"."SAMPLE_DATE">='01-apr-09')
225 - filter('TEMP'='FLOWDRY')
229 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09' AND
"SYS_ALIAS_2"."TAGNAME"='TEMP') filter("SYS_ALIAS_2"."TAGNAME"='TEMP' AND TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
231 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 234 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
236 - access("B"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='TEMPV') filter("B"."SAMPLE_DATE">='01-apr-09')
237 - filter('OPACMB6M'='FLOWDRY' AND 'OPAC6M'='FLOWDRY')
241 - access("SYS_ALIAS_2"."MILL_AREA"='KLN' AND "SYS_ALIAS_2"."SAMPLE_DATE">='01-apr-09')
filter(TRUNC("SYS_ALIAS_2"."SAMPLE_DATE")<='30-apr-09')
243 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN' AND "EMSSTATIONSTATUS"."EFFECTDATE"= (SELECT /*+ */ MAX("EMSSTATIONSTATUS"."EFFECTDATE") FROM "EMSSTATIONSTATUS" "EMSSTATIONSTATUS" WHERE "EMSSTATIONSTATUS"."EFFECTDATE"<=:B1 AND "EMSSTATIONSTATUS"."STATIONNUM"=:B2)) 246 - access("EMSSTATIONSTATUS"."STATIONNUM"=:B1 AND "EMSSTATIONSTATUS"."EFFECTDATE"<=:B2)
248 - access("B"."MILL_AREA"='KLN' AND "B"."SAMPLE_DATE"=TRUNC("SYS_ALIAS_2"."SAMPLE_DATE",'fmhh
') AND "B"."TAGNAME"='OPACV') Note: cpu costing is off
482 rows selected.
Elapsed: 00:00:00.07
Execution Plan
0 SELECT STATEMENT Optimizer=CHOOSE
1 0 COLLECTION ITERATOR (PICKLER FETCH) OF 'DISPLAY' Statistics
258 recursive calls
0 db block gets
2921 consistent gets
0 physical reads
0 redo size
46495 bytes sent via SQL*Net to client
851 bytes received via SQL*Net from client
34 SQL*Net roundtrips to/from client
33 sorts (memory)
0 sorts (disk)
482 rows processed
11g explain plan:
SQL> select * from table(dbms_xplan.display); Plan hash value: 3154918406
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ----------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 2305 | 137K| 4253 (4)| 00:00:52 | | 1 | HASH GROUP BY | | 2305 | 137K| 4253 (4)| 00:00:52 | | 2 | NESTED LOOPS | | 2305 | 137K| 4252 (4)| 00:00:52 | | 3 | VIEW | | 1 | 39 | 2126 (4)| 00:00:26 | | 4 | SORT AGGREGATE | | 1 | 13 | | | | 5 | VIEW | VW_CEM_CORR | 2305 | 29965 | 2126 (4)| 00:00:26 | | 6 | SORT UNIQUE | | 2305 | 211K| 2126 (100)| 00:00:26 | | 7 | UNION-ALL | | | | | | |* 8 | FILTER | | | | | | | 9 | HASH GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |* 10 | FILTER | | | | | | |* 11 | HASH JOIN | | 19291 | 1770K| 950 (2)| 00:00:12 | | 12 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |* 13 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |* 14 | HASH JOIN | | 436 | 31828 | 947 (2)| 00:00:12 | | 15 | NESTED LOOPS | | | | | | | 16 | NESTED LOOPS | | 14 | 840 | 945 (2)| 00:00:12 | | 17 | TABLE ACCESS BY INDEX ROWID| EMSCEMDETAIL | 14 | 420 | 917 (2)| 00:00:12 | |* 18 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 14 | | 906 (2)| 00:00:11 | |* 19 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 20 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |* 21 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | |* 22 | FILTER | | | | | | | 23 | HASH GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |* 24 | FILTER | | | | | | |* 25 | HASH JOIN | | 24785 | 2275K| 961 (2)| 00:00:12 | | 26 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |* 27 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |* 28 | HASH JOIN | | 560 | 40880 | 958 (2)| 00:00:12 | | 29 | NESTED LOOPS | | | | | | | 30 | NESTED LOOPS | | 18 | 1080 | 956 (2)| 00:00:12 | | 31 | TABLE ACCESS BY INDEX ROWID| EMSCEMDETAIL | 18 | 540 | 920 (2)| 00:00:12 | |* 32 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 18 | | 906 (2)| 00:00:11 | |* 33 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 34 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |* 35 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | |* 36 | FILTER | | | | | | | 37 | HASH GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |* 38 | FILTER | | | | | | |* 39 | HASH JOIN | | 19269 | 1768K| 950 (2)| 00:00:12 | | 40 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |* 41 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |* 42 | HASH JOIN | | 435 | 31755 | 947 (2)| 00:00:12 | | 43 | NESTED LOOPS | | | | | | | 44 | NESTED LOOPS | | 14 | 840 | 945 (2)| 00:00:12 | | 45 | TABLE ACCESS BY INDEX ROWID| EMSCEMDETAIL | 14 | 420 | 917 (2)| 00:00:12 | |* 46 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 14 | | 906 (2)| 00:00:11 | |* 47 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 48 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |* 49 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | |* 50 | FILTER | | | | | | | 51 | HASH GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |* 52 | FILTER | | | | | | |* 53 | HASH JOIN | | 19269 | 1768K| 950 (2)| 00:00:12 | | 54 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |* 55 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |* 56 | HASH JOIN | | 435 | 31755 | 947 (2)| 00:00:12 | | 57 | NESTED LOOPS | | | | | | | 58 | NESTED LOOPS | | 14 | 840 | 945 (2)| 00:00:12 | | 59 | TABLE ACCESS BY INDEX ROWID| EMSCEMDETAIL | 14 | 420 | 917 (2)| 00:00:12 | |* 60 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 14 | | 906 (2)| 00:00:11 | |* 61 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 62 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |* 63 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | |* 64 | FILTER | | | | | | | 65 | HASH GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |* 66 | FILTER | | | | | | |* 67 | HASH JOIN | | 589K| 52M| 2088 (1)| 00:00:26 | | 68 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |* 69 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |* 70 | HASH JOIN | | 13306 | 948K| 2082 (1)| 00:00:25 | |* 71 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | | 72 | NESTED LOOPS | | | | | | | 73 | NESTED LOOPS | | 429 | 25740 | 2081 (1)| 00:00:25 | | 74 | TABLE ACCESS BY INDEX ROWID| EMSCEMDETAIL | 425 | 12750 | 1230 (1)| 00:00:15 | |* 75 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 425 | | 906 (2)| 00:00:11 | |* 76 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 77 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |* 78 | FILTER | | | | | | | 79 | HASH GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |* 80 | FILTER | | | | | | |* 81 | HASH JOIN | | 577K| 51M| 2066 (1)| 00:00:25 | | 82 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |* 83 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |* 84 | HASH JOIN | | 13040 | 929K| 2060 (1)| 00:00:25 | |* 85 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | | 86 | NESTED LOOPS | | | | | | | 87 | NESTED LOOPS | | 420 | 25200 | 2059 (1)| 00:00:25 | | 88 | TABLE ACCESS BY INDEX ROWID| EMSCEMDETAIL | 417 | 12510 | 1224 (1)| 00:00:15 | |* 89 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 417 | | 906 (2)| 00:00:11 | |* 90 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 91 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |* 92 | FILTER | | | | | | | 93 | HASH GROUP BY | | 2296 | 210K| 2117 (3)| 00:00:26 | |* 94 | HASH JOIN | | 580K| 52M| 2071 (1)| 00:00:25 | | 95 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |* 96 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |* 97 | HASH JOIN | | 13112 | 934K| 2065 (1)| 00:00:25 | |* 98 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | | 99 | NESTED LOOPS | | | | | | | 100 | NESTED LOOPS | | 422 | 25320 | 2064 (1)| 00:00:25 | | 101 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 419 | 12570 | 1225 (1)| 00:00:15 | |*102 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 419 | | 906 (2)| 00:00:11 | |*103 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 104 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |*105 | FILTER | | | | | | | 106 | HASH GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |*107 | FILTER | | | | | | |*108 | HASH JOIN | | 580K| 52M| 2071 (1)| 00:00:25 | | 109 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |*110 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |*111 | HASH JOIN | | 13109 | 934K| 2065 (1)| 00:00:25 | |*112 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | | 113 | NESTED LOOPS | | | | | | | 114 | NESTED LOOPS | | 422 | 25320 | 2064 (1)| 00:00:25 | | 115 | TABLE ACCESS BY INDEX ROWID| EMSCEMDETAIL | 419 | 12570 | 1225 (1)| 00:00:15 | |*116 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 419 | | 906 (2)| 00:00:11 | |*117 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 118 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |*119 | FILTER | | | | | | | 120 | HASH GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |*121 | FILTER | | | | | | |*122 | HASH JOIN | | 564K| 50M| 2038 (1)| 00:00:25 | | 123 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |*124 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |*125 | HASH JOIN | | 12740 | 908K| 2032 (1)| 00:00:25 | |*126 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | | 127 | NESTED LOOPS | | | | | | | 128 | NESTED LOOPS | | 410 | 24600 | 2031 (1)| 00:00:25 | | 129 | TABLE ACCESS BY INDEX ROWID| EMSCEMDETAIL | 407 | 12210 | 1216 (1)| 00:00:15 | |*130 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 407 | | 906 (2)| 00:00:11 | |*131 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 132 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |*133 | FILTER | | | | | | | 134 | HASH GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |*135 | FILTER | | | | | | |*136 | HASH JOIN | | 47153 | 4328K| 2069 (1)| 00:00:25 | | 137 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |*138 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |*139 | HASH JOIN | | 1065 | 77745 | 2065 (1)| 00:00:25 | | 140 | NESTED LOOPS | | | | | | | 141 | NESTED LOOPS | | 34 | 2040 | 2064 (1)| 00:00:25 | | 142 | TABLE ACCESS BY INDEX ROWID| EMSCEMDETAIL | 419 | 12570 | 1225 (1)| 00:00:15 | |*143 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 419 | | 906 (2)| 00:00:11 | |*144 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 145 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |*146 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | | 147 | VIEW | VW_CEM_CORR | 2305 | 50710 | 2126 (4)| 00:00:26 | | 148 | SORT UNIQUE | | 2305 | 211K| 2126 (100)| 00:00:26 | | 149 | UNION-ALL | | | | | | |*150 | FILTER | | | | | | | 151 | SORT GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |*152 | FILTER | | | | | | |*153 | HASH JOIN | | 19291 | 1770K| 950 (2)| 00:00:12 | | 154 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |*155 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |*156 | HASH JOIN | | 436 | 31828 | 947 (2)| 00:00:12 | | 157 | NESTED LOOPS | | | | | | | 158 | NESTED LOOPS | | 14 | 840 | 945 (2)| 00:00:12 | | 159 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 14 | 420 | 917 (2)| 00:00:12 | |*160 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 14 | | 906 (2)| 00:00:11 | |*161 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 162 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |*163 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | |*164 | FILTER | | | | | | | 165 | SORT GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |*166 | FILTER | | | | | | |*167 | HASH JOIN | | 24785 | 2275K| 961 (2)| 00:00:12 | | 168 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |*169 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |*170 | HASH JOIN | | 560 | 40880 | 958 (2)| 00:00:12 | | 171 | NESTED LOOPS | | | | | | | 172 | NESTED LOOPS | | 18 | 1080 | 956 (2)| 00:00:12 | | 173 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 18 | 540 | 920 (2)| 00:00:12 | |*174 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 18 | | 906 (2)| 00:00:11 | |*175 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 176 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |*177 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | |*178 | FILTER | | | | | | | 179 | SORT GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |*180 | FILTER | | | | | | |*181 | HASH JOIN | | 19269 | 1768K| 950 (2)| 00:00:12 | | 182 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |*183 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |*184 | HASH JOIN | | 435 | 31755 | 947 (2)| 00:00:12 | | 185 | NESTED LOOPS | | | | | | | 186 | NESTED LOOPS | | 14 | 840 | 945 (2)| 00:00:12 | | 187 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 14 | 420 | 917 (2)| 00:00:12 | |*188 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 14 | | 906 (2)| 00:00:11 | |*189 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 190 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |*191 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | |*192 | FILTER | | | | | | | 193 | SORT GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |*194 | FILTER | | | | | | |*195 | HASH JOIN | | 19269 | 1768K| 950 (2)| 00:00:12 | | 196 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |*197 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |*198 | HASH JOIN | | 435 | 31755 | 947 (2)| 00:00:12 | | 199 | NESTED LOOPS | | | | | | | 200 | NESTED LOOPS | | 14 | 840 | 945 (2)| 00:00:12 | | 201 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 14 | 420 | 917 (2)| 00:00:12 | |*202 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 14 | | 906 (2)| 00:00:11 | |*203 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 204 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |*205 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | |*206 | FILTER | | | | | | | 207 | SORT GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |*208 | FILTER | | | | | | |*209 | HASH JOIN | | 589K| 52M| 2088 (1)| 00:00:26 | | 210 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |*211 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |*212 | HASH JOIN | | 13306 | 948K| 2082 (1)| 00:00:25 | |*213 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | | 214 | NESTED LOOPS | | | | | | | 215 | NESTED LOOPS | | 429 | 25740 | 2081 (1)| 00:00:25 | | 216 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 425 | 12750 | 1230 (1)| 00:00:15 | |*217 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 425 | | 906 (2)| 00:00:11 | |*218 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 219 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |*220 | FILTER | | | | | | | 221 | SORT GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |*222 | FILTER | | | | | | |*223 | HASH JOIN | | 577K| 51M| 2066 (1)| 00:00:25 | | 224 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |*225 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |*226 | HASH JOIN | | 13040 | 929K| 2060 (1)| 00:00:25 | |*227 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | | 228 | NESTED LOOPS | | | | | | | 229 | NESTED LOOPS | | 420 | 25200 | 2059 (1)| 00:00:25 | | 230 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 417 | 12510 | 1224 (1)| 00:00:15 | |*231 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 417 | | 906 (2)| 00:00:11 | |*232 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 233 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |*234 | FILTER | | | | | | | 235 | SORT GROUP BY | | 2296 | 210K| 2117 (3)| 00:00:26 | |*236 | HASH JOIN | | 580K| 52M| 2071 (1)| 00:00:25 | | 237 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |*238 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |*239 | HASH JOIN | | 13112 | 934K| 2065 (1)| 00:00:25 | |*240 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | | 241 | NESTED LOOPS | | | | | | | 242 | NESTED LOOPS | | 422 | 25320 | 2064 (1)| 00:00:25 | | 243 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 419 | 12570 | 1225 (1)| 00:00:15 | |*244 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 419 | | 906 (2)| 00:00:11 | |*245 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 246 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |*247 | FILTER | | | | | | | 248 | SORT GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |*249 | FILTER | | | | | | |*250 | HASH JOIN | | 580K| 52M| 2071 (1)| 00:00:25 | | 251 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |*252 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |*253 | HASH JOIN | | 13109 | 934K| 2065 (1)| 00:00:25 | |*254 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | | 255 | NESTED LOOPS | | | | | | | 256 | NESTED LOOPS | | 422 | 25320 | 2064 (1)| 00:00:25 | | 257 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 419 | 12570 | 1225 (1)| 00:00:15 | |*258 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 419 | | 906 (2)| 00:00:11 | |*259 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 260 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |*261 | FILTER | | | | | | | 262 | SORT GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |*263 | FILTER | | | | | | |*264 | HASH JOIN | | 564K| 50M| 2038 (1)| 00:00:25 | | 265 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |*266 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |*267 | HASH JOIN | | 12740 | 908K| 2032 (1)| 00:00:25 | |*268 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | | 269 | NESTED LOOPS | | | | | | | 270 | NESTED LOOPS | | 410 | 24600 | 2031 (1)| 00:00:25 | | 271 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 407 | 12210 | 1216 (1)| 00:00:15 | |*272 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 407 | | 906 (2)| 00:00:11 | |*273 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 274 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |*275 | FILTER | | | | | | | 276 | SORT GROUP BY | | 1 | 94 | 1 (100)| 00:00:01 | |*277 | FILTER | | | | | | |*278 | HASH JOIN | | 47153 | 4328K| 2069 (1)| 00:00:25 | | 279 | TABLE ACCESS BY INDEX ROWID | EMSSTATIONSTATUS | 44 | 924 | 3 (0)| 00:00:01 | |*280 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | | 1 (0)| 00:00:01 | |*281 | HASH JOIN | | 1065 | 77745 | 2065 (1)| 00:00:25 | | 282 | NESTED LOOPS | | | | | | | 283 | NESTED LOOPS | | 34 | 2040 | 2064 (1)| 00:00:25 | | 284 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 419 | 12570 | 1225 (1)| 00:00:15 | |*285 | INDEX RANGE SCAN | PK_EMSCEMDETAIL | 419 | | 906 (2)| 00:00:11 | |*286 | INDEX UNIQUE SCAN | PK_EMSCEMDETAIL | 1 | | 1 (0)| 00:00:01 | | 287 | TABLE ACCESS BY INDEX ROWID | EMSCEMDETAIL | 1 | 30 | 2 (0)| 00:00:01 | |*288 | INDEX RANGE SCAN | PK_DWQSTATIONSTATUS | 44 | 572 | 1 (0)| 00:00:01 | -----------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
8 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
10 - filter(NULL IS NOT NULL)
11 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
13 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
14 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
18 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='TRSC12HR')
filter("A"."TAGNAME"='TRSC12HR' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
19 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='TRSC12V') filter("B"."SAMPLE_DATE">='01-apr-09')
21 - access("STATIONNUM"='KLN')
22 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
24 - filter(NULL IS NOT NULL)
25 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
27 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
28 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
32 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='TRSM12HR')
filter("A"."TAGNAME"='TRSM12HR' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
33 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='TRSM12V') filter("B"."SAMPLE_DATE">='01-apr-09')
35 - access("STATIONNUM"='KLN')
36 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
38 - filter(NULL IS NOT NULL)
39 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
41 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
42 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
46 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='SO2M12HR')
filter("A"."TAGNAME"='SO2M12HR' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
47 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='SO2M12V') filter("B"."SAMPLE_DATE">='01-apr-09')
49 - access("STATIONNUM"='KLN')
50 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
52 - filter(NULL IS NOT NULL)
53 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
55 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
56 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
60 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='SO2COMP')
filter("A"."TAGNAME"='SO2COMP' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
61 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='SO2C12V') filter("B"."SAMPLE_DATE">='01-apr-09')
63 - access("STATIONNUM"='KLN')
64 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
66 - filter(NULL IS NOT NULL)
67 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
69 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
70 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
71 - access("STATIONNUM"='KLN')
75 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='O2')
filter("A"."TAGNAME"='O2' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
76 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='O2V') filter("B"."SAMPLE_DATE">='01-apr-09')
78 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
80 - filter(NULL IS NOT NULL)
81 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
83 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
84 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
85 - access("STATIONNUM"='KLN')
89 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='CO')
filter("A"."TAGNAME"='CO' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
90 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='COV') filter("B"."SAMPLE_DATE">='01-apr-09')
92 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
94 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
96 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
97 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
98 - access("STATIONNUM"='KLN')
102 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='FLOWDRY')
filter("A"."TAGNAME"='FLOWDRY' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
103 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='FLOWV') filter("B"."SAMPLE_DATE">='01-apr-09')
105 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
107 - filter(NULL IS NOT NULL)
108 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
110 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
111 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
112 - access("STATIONNUM"='KLN')
116 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='FLOWDRY')
filter("A"."TAGNAME"='FLOWDRY' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
117 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='OPACV') filter("B"."SAMPLE_DATE">='01-apr-09')
119 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
121 - filter(NULL IS NOT NULL)
122 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
124 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
125 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
126 - access("STATIONNUM"='KLN')
130 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='TEMP')
filter("A"."TAGNAME"='TEMP' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
131 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='TEMPV') filter("B"."SAMPLE_DATE">='01-apr-09')
133 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
135 - filter(NULL IS NOT NULL)
136 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
138 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
139 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
143 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='FLOWDRY')
filter("A"."TAGNAME"='FLOWDRY' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
144 - access("B"."MILL_AREA"='KLN' AND "B"."SAMPLE_DATE"=TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"),'fmh
h') AND "B"."TAGNAME"='OPACV')
146 - access("STATIONNUM"='KLN')
150 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
152 - filter(NULL IS NOT NULL)
153 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
155 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
156 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
160 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='TRSC12HR')
filter("A"."TAGNAME"='TRSC12HR' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
161 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='TRSC12V') filter("B"."SAMPLE_DATE">='01-apr-09')
163 - access("STATIONNUM"='KLN')
164 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
166 - filter(NULL IS NOT NULL)
167 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
169 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
170 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
174 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='TRSM12HR')
filter("A"."TAGNAME"='TRSM12HR' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
175 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='TRSM12V') filter("B"."SAMPLE_DATE">='01-apr-09')
177 - access("STATIONNUM"='KLN')
178 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
180 - filter(NULL IS NOT NULL)
181 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
183 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
184 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
188 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='SO2M12HR')
filter("A"."TAGNAME"='SO2M12HR' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
189 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='SO2M12V') filter("B"."SAMPLE_DATE">='01-apr-09')
191 - access("STATIONNUM"='KLN')
192 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
194 - filter(NULL IS NOT NULL)
195 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
197 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
198 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
202 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='SO2COMP')
filter("A"."TAGNAME"='SO2COMP' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
203 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='SO2C12V') filter("B"."SAMPLE_DATE">='01-apr-09')
205 - access("STATIONNUM"='KLN')
206 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
208 - filter(NULL IS NOT NULL)
209 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
211 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
212 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
213 - access("STATIONNUM"='KLN')
217 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='O2')
filter("A"."TAGNAME"='O2' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
218 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='O2V') filter("B"."SAMPLE_DATE">='01-apr-09')
220 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
222 - filter(NULL IS NOT NULL)
223 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
225 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
226 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
227 - access("STATIONNUM"='KLN')
231 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='CO')
filter("A"."TAGNAME"='CO' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
232 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='COV') filter("B"."SAMPLE_DATE">='01-apr-09')
234 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
236 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
238 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
239 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
240 - access("STATIONNUM"='KLN')
244 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='FLOWDRY')
filter("A"."TAGNAME"='FLOWDRY' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
245 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='FLOWV') filter("B"."SAMPLE_DATE">='01-apr-09')
247 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
249 - filter(NULL IS NOT NULL)
250 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
252 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
253 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
254 - access("STATIONNUM"='KLN')
258 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='FLOWDRY')
filter("A"."TAGNAME"='FLOWDRY' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
259 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='OPACV') filter("B"."SAMPLE_DATE">='01-apr-09')
261 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
263 - filter(NULL IS NOT NULL)
264 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
266 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
267 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
268 - access("STATIONNUM"='KLN')
272 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='TEMP')
filter("A"."TAGNAME"='TEMP' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
273 - access("B"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE"="B"."SAMPLE_DATE" AND "B"."TAGNAME"='TEMPV') filter("B"."SAMPLE_DATE">='01-apr-09')
275 - filter("EFFECTDATE"=MAX("EFFECTDATE"))
277 - filter(NULL IS NOT NULL)
278 - access("EMSSTATIONSTATUS"."STATIONNUM"="A"."MILL_AREA")
280 - access("EMSSTATIONSTATUS"."STATIONNUM"='KLN')
281 - access("STATIONNUM"="A"."MILL_AREA")
filter("EFFECTDATE"<="A"."SAMPLE_DATE")
285 - access("A"."MILL_AREA"='KLN' AND "A"."SAMPLE_DATE">='01-apr-09'
AND "A"."TAGNAME"='FLOWDRY')
filter("A"."TAGNAME"='FLOWDRY' AND
TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"))<='30-apr-09')
286 - access("B"."MILL_AREA"='KLN' AND "B"."SAMPLE_DATE"=TRUNC(INTERNAL_FUNCTION("A"."SAMPLE_DATE"),'fmh
h') AND "B"."TAGNAME"='OPACV')
288 - access("STATIONNUM"='KLN')
517 rows selected.
Execution Plan
Plan hash value: 2137789089
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | --------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 8168 | 16336 |29 (0)| 00:00:01 |
| 1 | COLLECTION ITERATOR PICKLER FETCH| DISPLAY | 8168 | 16336 | 29 (0)| 00:00:01 |
Statistics
4029 recursive calls
48 db block gets
3786 consistent gets
77 physical reads
0 redo size
54286 bytes sent via SQL*Net to client
894 bytes received via SQL*Net from client
36 SQL*Net roundtrips to/from client
78 sorts (memory)
0 sorts (disk)
517 rows processed Received on Wed May 26 2010 - 11:25:42 CDT