OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » trying to find the user highwater mark

Home » Applications » Oracle Fusion Apps & E-Business Suite » trying to find the user highwater mark

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

trying to find the user highwater mark [message #161238]

Thu, 02 March 2006 15:30

madchaz
Messages: 65
Registered: October 2005

Member

I'm trying to find what is the high water mark for the number of users loged into oracle applications at one time. I've looked in metalink but can't find where I'm supposed to look. Anyone as a pointer for me?

Report message to a moderator

Re: trying to find the user highwater mark [message #161278 is a reply to message #161238]

Fri, 03 March 2006 00:57

Frank
Messages: 7901
Registered: March 2000

Senior Member

SQL> select * From v$license;

SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER  USERS_MAX CPU_COUNT_CURRENT CPU_C
------------ ---------------- ---------------- ------------------ ---------- ----------------- -----
CPU_SOCKET_COUNT_CURRENT CPU_COUNT_HIGHWATER CPU_CORE_COUNT_HIGHWATER CPU_SOCKET_COUNT_HIGHWATER
------------------------ ------------------- ------------------------ --------------------------
           0                0                3                  3          0                 1
                                           1

It is the sessions_highwater column.

Clearly, this is my home-db Wink

Report message to a moderator

Re: trying to find the user highwater mark [message #161346 is a reply to message #161238]

Fri, 03 March 2006 06:55

madchaz
Messages: 65
Registered: October 2005

Member

Thanks

useful information, but turns out what I needed was the highwater mark for Apps login in a day. I love when the question asked is so vague it can be taken 10 different ways. That'll be a lot harder to get I think.

[Updated on: Fri, 03 March 2006 07:11]

Report message to a moderator

Re: trying to find the user highwater mark [message #161355 is a reply to message #161346]

Fri, 03 March 2006 07:29

Frank
Messages: 7901
Registered: March 2000

Senior Member

Sorry, I don't know apps. Shall I move this topic to the Apps-forum?

Report message to a moderator

Re: trying to find the user highwater mark [message #161356 is a reply to message #161355]

Fri, 03 March 2006 07:32

madchaz
Messages: 65
Registered: October 2005

Member

Sure. Maybe someone there as an awnser. I found a way to give me the current users. If nothing else, I'll probably just manualy monitor it and take notes.

In "Application Manager", under "Performance", you can see the current number of users loged in throught the forms.

Report message to a moderator

Previous Topic:	SOE in Indian Payroll
Next Topic:	Pegging.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 09:49:49 CST 2024