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