APPS.FND_PERFMON dependencies on FND_WAIT_SAMPLES

Line 18: delete from fnd_wait_samples

14: update fnd_perf_variables set value = to_char(new_expire)
15: where variable = 'wait_sample_expiration';
16:
17: /* Delete expired samples. */
18: delete from fnd_wait_samples
19: where snapdate < sysdate - new_expire;
20: commit;
21: end;
22:

Line 53: delete from fnd_wait_samples

49: begin
50:
51: /* Delete expired samples. */
52: wait_sample_expiration := get_wait_sample_expiration;
53: delete from fnd_wait_samples
54: where snapdate < sysdate - wait_sample_expiration;
55:
56: /* Take sample. */
57: insert into fnd_wait_samples( ct, event, detail, fgbg, rtbt, snapdate )

Line 57: insert into fnd_wait_samples( ct, event, detail, fgbg, rtbt, snapdate )

53: delete from fnd_wait_samples
54: where snapdate < sysdate - wait_sample_expiration;
55:
56: /* Take sample. */
57: insert into fnd_wait_samples( ct, event, detail, fgbg, rtbt, snapdate )
58: -- Identify the DB Message wait sessions
59: select count (*),
60: 'DBW',
61: decode( w.wait_time, 0, decode( w.event, 'latch free', w.p2, w.p1 ), NULL ),