APPS.FND_PERFMON dependencies on FND_SQL_SAMPLES

Line 187: delete from fnd_sql_samples

183: update fnd_perf_variables set value = to_char(new_expire)
184: where variable = 'sql_sample_expiration';
185:
186: /* Delete expired samples. */
187: delete from fnd_sql_samples
188: where snapdate < sysdate - new_expire;
189: commit;
190: end;
191:

Line 221: delete from fnd_sql_samples

217: begin
218:
219: /* Delete expired samples. */
220: sql_sample_expiration := get_sql_sample_expiration;
221: delete from fnd_sql_samples
222: where snapdate < sysdate - sql_sample_expiration;
223:
224: /* Take sample. */
225: insert into fnd_sql_samples(sql_hash_value, type, program, snapdate)

Line 225: insert into fnd_sql_samples(sql_hash_value, type, program, snapdate)

221: delete from fnd_sql_samples
222: where snapdate < sysdate - sql_sample_expiration;
223:
224: /* Take sample. */
225: insert into fnd_sql_samples(sql_hash_value, type, program, snapdate)
226: select s.sql_hash_value,
227: decode(w.WAIT_TIME,
228: 0, decode(w.event, 'db file sequential read', 'R', 'S'),
229: 'C'),