eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_PERFMON dependencies on V$SESSION

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 71: (select s2.sid from v$session s2

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' ))
73: and w.wait_time <> 0
74: and exists ( select 1
75: from v$session s3

Line 75: from v$session s3

71: (select s2.sid from v$session s2
72: where s2.audsid = userenv( 'SESSIONID' ))
73: and w.wait_time <> 0
74: and exists ( select 1
75: from v$session s3
76: where
77: s.paddr = s3.paddr
78: and s.sid <> s3.sid )
79: group by 2,

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 127: (select s2.sid from v$session s2

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' ))
129: and (w.wait_time = 0
130: or not exists ( select 1
131: from v$session s3

Line 131: from v$session s3

127: (select s2.sid from v$session s2
128: where s2.audsid = userenv( 'SESSIONID' ))
129: and (w.wait_time = 0
130: or not exists ( select 1
131: from v$session s3
132: where
133: s.paddr = s3.paddr
134: and s.sid <> s3.sid ) )
135: group by decode( w.wait_time,

Line 212: -- Sample v$session to capture

208:
209:
210: --
211: -- TAKE_SQL_SAMPLE
212: -- Sample v$session to capture
213: -- the sql currently being executed by every session.
214: --
215: procedure TAKE_SQL_SAMPLE is
216: sql_sample_expiration float;

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

Line 237: (select 1 from v$session s3 where s.paddr = s3.paddr and s.sid <> s3.sid))

233: where
234: w.sid = s.sid
235: and ((w.WAIT_TIME <> 0 -- CPU case
236: and not exists
237: (select 1 from v$session s3 where s.paddr = s3.paddr and s.sid <> s3.sid))
238: or
239: (w.WAIT_TIME = 0 -- I/O case
240: and w.event in ('db file scattered read', 'db file sequential read')
241: ));