How many users are currently connected to Applicat

[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

[karthick_jk]

hi

u can check in security-> user -> monitor ...

regards
karthick

[waqar840]

Dear karthick

Thanks for info.

I checked this but no entry found on your given path.

Please clarify this.

Regards,

WAQAR

[anandsoni]

Hi ,

Check FND_LOGINS table

Regards,

Anand

[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

[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

[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

[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>

[latif]

Hi Waqar,

If you have performed first two steps then just query

system administrator-->security--user-->monitor(ctrl+f11)

bye

[waqar840]

Dear Mr.Latif

Bunle of Thanks .

Problem sovled as you provided given solution.

Regards,

WAQAR

[admin]

Try the following query as well,

SELECT COUNT (*)
FROM v$session
WHERE schemaname = 'APPS' AND program = 'JDBC Thin Client'