SYS.DBMS_FEATURE_EMX dependencies on DUAL

Line 138: from dual;

134: l_report_usage_key || '//@avg_cpu_time'), 0)
135: into l_old_report_count,
136: l_old_report_avg_time,
137: l_old_report_avg_cputime
138: from dual;
139:
140: -- update the statistics, increment count and total time with stats
141: -- since the last usage collection
142: l_new_report_count

Line 163: from dual;

159: l_new_report_avg_time,
160: l_report_usage_key || '//@avg_cpu_time',
161: l_new_report_avg_cputime)
162: into l_detailed_usage_xml
163: from dual;
164:
165: -- if no xml element is found for this report, construct a new one
166: else
167: -- calculate average time

Line 181: from dual;

177: l_new_report_count as "count",
178: l_new_report_avg_time as "avg_elapsed_time",
179: l_new_report_avg_cputime as "avg_cpu_time"))
180: into l_report_usage_xml
181: from dual;
182:
183: -- append this report usage to the main emx feature usage xml
184: l_detailed_usage_xml :=
185: l_detailed_usage_xml.appendChildxml('/*', l_report_usage_xml);