APPS.FND_PERFMON dependencies on V$SESSION_WAIT

Line 43: -- Sample v$session_wait to capture:

39:
40:
41: --
42: -- TAKE_WAIT_SAMPLE
43: -- Sample v$session_wait to capture:
44: -- encoded event, background or foreground, batch or real-time, snapdate,
45: -- and group similar events so it records a count for the group.
46: --
47: procedure TAKE_WAIT_SAMPLE is

Line 68: from v$session_wait w, v$session s

64: ' ? @', /* real-time programs have this funny name */
65: decode( s.terminal, NULL, 'B', 'R' ),
66: 'B' ),
67: sysdate
68: from v$session_wait w, v$session s
69: where s.sid = w.sid
70: and s.sid not in
71: (select s2.sid from v$session s2
72: where s2.audsid = userenv( 'SESSIONID' ))

Line 124: from v$session_wait w, v$session s

120: ' ? @', /* real-time programs have this funny name */
121: decode( s.terminal, NULL, 'B', 'R' ),
122: 'B' ),
123: sysdate
124: from v$session_wait w, v$session s
125: where s.sid = w.sid
126: and s.sid not in
127: (select s2.sid from v$session s2
128: where s2.audsid = userenv( 'SESSIONID' ))

Line 232: from v$session s, v$session_wait w

228: 0, decode(w.event, 'db file sequential read', 'R', 'S'),
229: 'C'),
230: substr(s.program,1,8),
231: sysdate
232: from v$session s, v$session_wait w
233: where
234: w.sid = s.sid
235: and ((w.WAIT_TIME <> 0 -- CPU case
236: and not exists