Page 1 of 1
How many users are currently connected to Applicat
Posted: Mon Dec 24, 2007 8:05 am
by waqar840
Dear All,
I want to see how many users are currently connected to 11i E-Business Suite Application . Please tell me, How I check .
Thanks in Advance .
Regards,
WAQAR
Posted: Sat Dec 29, 2007 2:53 am
by karthick_jk
hi
u can check in security-> user -> monitor ...
regards
karthick
Posted: Sat Dec 29, 2007 4:44 am
by waqar840
Dear karthick
Thanks for info.
I checked this but no entry found on your given path.
Please clarify this.
Regards,
WAQAR
Posted: Sat Dec 29, 2007 5:13 am
by anandsoni
Hi ,
Check FND_LOGINS table
Regards,
Anand
Posted: Mon Dec 31, 2007 10:02 am
by latif
Hi;
Hope it 'll help you.
-set the profile option (Sign-On:Audit Level) value to form. By default it is set to none.
-run the concurrent program (OAM Applications Dashboard Collection) this concurrent will fill some tables like fnd_oam_forms_rti with important data like IP address of the client, time, ?etc.
-go to Oracle applications manager (OAM) and from the drop down menu choose (forms sessions) this will give you users that are connected to your apps with their responsibilities, user id, time, and which from are they using and a lot of other info.
Mohammed Latif
Posted: Mon Dec 31, 2007 10:18 am
by waqar840
Dear Mohammed Latif Sb.
This is really help ful for me.
I perform first two steps but i can not find oracle application manager .
Please tell me the url or others tips how i see OAM.
Bundle of Thnaks
Regard WAQAR
Posted: Mon Dec 31, 2007 10:36 am
by waqar840
Dear Mohammad Latif Sb.
I also found Oracle OAM Url and go there on your given path but there are on form session it gives only two user but in V$session it shows 118 sessions.
How you see this matter.
Regards,
WAQAR
Posted: Tue Jan 01, 2008 2:12 am
by ahmadbilal
Displays session information for Oracle Applications R11i ! Will only work if AUDIT is set for USER Level !!
<b>
http://www.dbatoolz.com/sql/a_user_ses_R11i.sql</b>
Dear All,
I want to see how many users are currently connected to 11i E-Business Suite Application . Please tell me, How I check .
Thanks in Advance .
Regards,
WAQAR
<i><div align="right">Originally posted by waqar840 - Dec 24 2007 : 03:05:46 AM</div id="right"></i>
Posted: Wed Jan 02, 2008 2:21 am
by latif
Hi Waqar,
If you have performed first two steps then just query
system administrator-->security--user-->monitor(ctrl+f11)
bye
Posted: Thu Jan 03, 2008 3:18 am
by waqar840
Dear Mr.Latif
Bunle of Thanks .
Problem sovled as you provided given solution.
Regards,
WAQAR
Posted: Thu Jan 03, 2008 3:35 am
by admin
Try the following query as well,
SELECT COUNT (*)
FROM v$session
WHERE schemaname = 'APPS' AND program = 'JDBC Thin Client'