After Oracle OAM enables single-point logon, you can view the number of currently logged-on users. oracleoam

Source: Internet
Author: User

After Oracle OAM enables single-point logon, you can view the number of currently logged-on users. oracleoam

Background:

After a project is launched, especially portal projects, it is often required to count the number of online users. How can we accurately count the number of online users in the current system? The following describes the query method.

Query Method:

Method 1:

On the oamconsole, View session management. You can see that this page is a standard query of the ADF, and the query panel is on top. There are two search conditions: user IP address and Client IP address, k can enter the Client IP address for fuzzy search. This IP address is generally the IP address of the OHS server.

In this way, the user's online status can be searched, but this method has some drawbacks, that is, only 100 users can be searched. When the number of online users exceeds 100, it cannot be completely displayed, this is restricted by the product background query. Do we have other methods to query the online status of all users? The answer is yes.

Method 2:

Analysis: From method 1, we can see that the display of user records must be supported by underlying tables in the background. When we install Oam to create RCU, a Schema is automatically created, if you find the table in this Schema that stores user logon information, can the problem be solved?

1. First, determine the name of the newly created Schema when installing Oam to create RCU, which generally ends with _ OAM

2. log on to the Schema in pl/SQL and view the Table. You will find a Table named oam_session. That's right, it's the underlying Table in it. Run the following query statement:

To view the current user's online status

Selectuserid,

To_char (s. last_access_time, 'yyyy-mm-dd hh24: mi: ss') create_date,

To_char (s. last_update_time, 'yyyy-mm-dd hh24: mi: ss') update_date

Fromoam_session s

Wheres. identity_domain = 'useridentitystore1'

Orderbyupdate_datedesc

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.