|
4258
2006-AUG-07 14:26:10
|
|
Moderator
|
|
|
Registered On: Mar 2006
Total Posts: 233
|
|
11.5.10.2 APPS active middle-tier user sessions script is
build on top of the following tables:
fnd_logins
fnd_user
v$process
v$session
This script will allow you to report on either WEB or FORMS connections.
Sample output:
06:00:04 APPS@COMP:ser1> @a_user_ses_R11i.10.2.sql
Enter the type of sessions you'd like to report on [web|frm]: frm
Session altered.
old 14: where decode('&&1','web',fl.spid,1)=decode('&&1','web',s.process,1)
new 14: where decode('frm','web',fl.spid,1)=decode('frm','web',s.process,1)
-- Apps --
DB-PID MT-PID USR:SID,SERIAL Logon Time Apps User Middle Tier Module Module Detail
------ ------ ---------------- --------------- ------------ --------------- ---------- -----------------------------------
2759 29722 APPS:54,11200 JAN-10 12:25 FST midtier.applmgr FNDSCSGN Comp1 Quality Data Collection
8039 2267 APPS:56,15166 JAN-08 06:59 ANASOCTA midtier.applmgr FNDSCSGN Comp2 NA System Administrator
8039 2267 APPS:100,7794 JAN-08 06:59 ANASOCTA midtier.applmgr FNDSCAUS FRM:ANASOCTA:Comp2 NA System A
18153 28439 APPS:137,20169 JAN-11 05:39 BDOLSING midtier.applmgr FNDSCSGN Comp2 OM Manager 2
13684 27954 APPS:161,23900 JAN-11 05:32 GUEST midtier.applmgr POXRQERQ FRM:GDOUGLAS:Requisitions - COM
17453 4935 APPS:178,16991 JAN-10 15:10 GMULIGAN midtier.applmgr FNDSCSGN COM_OZ
2455 26430 APPS:189,21028 JAN-11 05:14 KRUPLAIS midtier.applmgr APXINWKB FRM:KRUPLAIS:Payables Administra
29218 5851 APPS:206,1725 JAN-08 09:05 WSRIGHT midtier.applmgr FNDSCSGN Comp2 OM Manager 2
29218 5851 APPS:218,10694 JAN-08 09:05 WSRIGHT midtier.applmgr FNDRSRUN FRM:WSRIGHT:Comp2 OM Manager 2
19560 23496 APPS:236,9943 JAN-11 05:32 GDOUGLAS midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-11 05:11 GUEST midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-11 02:24 GUEST midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-11 02:15 GUEST midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-11 01:09 GUEST midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-11 00:52 GUEST midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-10 21:01 VPOH midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-10 18:15 GUEST midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-10 18:14 GUEST midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-10 18:09 GUEST midtier.applmgr fnd.framew 23496
2455 26430 APPS:242,11188 JAN-11 05:14 KRUPLAIS midtier.applmgr POXPOVPO FRM:KRUPLAIS:Payables Administra
11913 23496 APPS:246,9298 JAN-11 05:23 GUEST midtier.applmgr fnd.wf.wor 23496
11913 23496 APPS:246,9298 JAN-10 23:28 PSARNA.SHARM midtier.applmgr fnd.wf.wor 23496
A@SIPRA.COM
11913 23496 APPS:246,9298 JAN-10 12:48 CBRAIN@TERRA midtier.applmgr fnd.wf.wor 23496
COLO.COM
2759 29722 APPS:251,7085 JAN-10 12:25 FST midtier.applmgr QLTRSMDF FRM:FST:Comp1 Quality Data Colle
12624 23496 APPS:255,2896 JAN-11 05:10 GUEST midtier.applmgr fnd.wf.wor 23496
12624 23496 APPS:255,2896 JAN-10 22:13 GUEST midtier.applmgr fnd.wf.wor 23496
13684 27954 APPS:262,16329 JAN-11 05:32 GUEST midtier.applmgr POXRQVRQ FRM:GDOUGLAS:Requisitions - COM
12599 23496 APPS:270,7029 JAN-11 05:37 GUEST midtier.applmgr fnd.framew 23496
18127 23496 APPS:293,4148 JAN-10 22:19 LINASA@CACCT midtier.applmgr pos.isp.se 23496
N.COM.TW
18127 23496 APPS:293,4148 JAN-10 21:04 LINASA@CACCT midtier.applmgr pos.isp.se 23496
N.COM.TW
18127 23496 APPS:293,4148 JAN-10 20:06 SPREMA midtier.applmgr pos.isp.se 23496
18127 23496 APPS:293,4148 JAN-10 17:14 FPANGTON midtier.applmgr pos.isp.se 23496
13684 27954 APPS:296,15625 JAN-11 05:32 GUEST midtier.applmgr FNDSCSGN Requisitions - COM
18153 28439 APPS:315,6912 JAN-11 05:39 BDOLSING midtier.applmgr FNDRSRUN FRM:BDOLSING:Comp2 OM Manager
27761 26026 APPS:316,17905 JAN-11 04:18 PSERTA midtier.applmgr FNDSCSGN Shipping Administrator-COM
2455 26430 APPS:323,9527 JAN-11 05:14 KRUPLAIS midtier.applmgr FNDSCSGN Payables Administrator GUI - COM
1897 22505 APPS:326,4932 JAN-10 07:45 GUEST midtier.applmgr QLTRSMDF FRM:FST:Comp1 Quality Data Colle
18853 25556 APPS:330,6697 JAN-11 04:04 PSYTVE midtier.applmgr FNDSCSGN C/S Receivables Manager GUI
2455 26430 APPS:333,5548 JAN-11 05:14 KRUPLAIS midtier.applmgr APXINWKB FRM:KRUPLAIS:Payables Administra
1897 22505 APPS:346,2507 JAN-10 07:45 GUEST midtier.applmgr FNDSCSGN Comp1 Quality Data Collection
40 rows selected.
06:00:13 APPS@COMP:ser1>
06:00:13 APPS@COMP:ser1> @a_user_ses_R11i.10.2.sql
Enter the type of sessions you'd like to report on [web|frm]: web
Session altered.
old 14: where decode('&&1','web',fl.spid,1)=decode('&&1','web',s.process,1)
new 14: where decode('web','web',fl.spid,1)=decode('web','web',s.process,1)
-- Apps --
DB-PID MT-PID USR:SID,SERIAL Logon Time Apps User Middle Tier Module Module Detail
------ ------ ---------------- --------------- ------------ --------------- ---------- -----------------------------------
19560 23496 APPS:236,9943 JAN-11 05:32 GDOUGLAS midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-11 05:11 GUEST midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-11 02:24 GUEST midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-11 02:15 GUEST midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-11 01:09 GUEST midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-11 00:52 GUEST midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-10 21:01 VPOH midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-10 18:15 GUEST midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-10 18:14 GUEST midtier.applmgr fnd.framew 23496
19560 23496 APPS:236,9943 JAN-10 18:09 GUEST midtier.applmgr fnd.framew 23496
11913 23496 APPS:246,9298 JAN-11 05:23 GUEST midtier.applmgr fnd.wf.wor 23496
11913 23496 APPS:246,9298 JAN-10 23:28 PSARNA.SHARM midtier.applmgr fnd.wf.wor 23496
A@WIPRO.COM
11913 23496 APPS:246,9298 JAN-10 12:48 CBRAIN@TERRA midtier.applmgr fnd.wf.wor 23496
COLO.COM
12624 23496 APPS:255,2896 JAN-11 05:10 GUEST midtier.applmgr fnd.wf.wor 23496
12624 23496 APPS:255,2896 JAN-10 22:13 GUEST midtier.applmgr fnd.wf.wor 23496
12599 23496 APPS:270,7029 JAN-11 05:37 GUEST midtier.applmgr fnd.framew 23496
18127 23496 APPS:293,4148 JAN-10 22:19 LINASA@CACCT midtier.applmgr pos.isp.se 23496
N.COM.TW
18127 23496 APPS:293,4148 JAN-10 21:04 LINASA@CACCT midtier.applmgr pos.isp.se 23496
N.COM.TW
18127 23496 APPS:293,4148 JAN-10 20:06 SPREMA midtier.applmgr pos.isp.se 23496
18127 23496 APPS:293,4148 JAN-10 17:14 FPANGTON midtier.applmgr pos.isp.se 23496
20 rows selected.
06:00:36 APPS@COMP:ser1>
[edited by: Vitaliy at 17:53 (CST) on Jan. 11, 2007]