License metrics and concurrent usage

The Concurrent License Agent gathers the active user count, for every license, at a fixed recurring interval of time. As a background agent, it is not available or exposed to administrators for configuration or management within the Administrator Console > Agents page. The Concurrent License Agent starts on server startup, and only one instance of it will run at any given time, whether it's in a single-server or multi-server environment.

The Concurrent License Agent checks and records active usage every 10 minutes. This time value is not configurable. Upon waking up, the agent queries the ACTIVE_SESSION table and gets all of the users that are logged in the application at that moment. Then the agent gathers all of the associated licenses for each user, and logs the information in the LICENSE_METRIC table. If there are no active users at the time of the snapshot, no entries are recorded in the table.

The following image shows a partial view of the LICENSE_METRIC table, including the snapshot time, total user count, and the user count for each individual license. Each row represents a time when the Concurrent License Agent woke up, saw active users in the system, and recorded the total user count, as well as the total count of each license ID that is assigned to those users cumulatively.

Example of the LICENSE_METRIC table

Six reports are available that capture the information of the user load and license usage in the system.

The "User Load Reports" (Hourly, Daily or Monthly) get the maximum number of users who log into the system over a period of time:

• Hourly User Load Report for Selected Day
• Daily User Load Report for Selected Month
• Monthly User Load Report for Selected Year

The "License Usage Reports" (Hourly, Daily or Monthly) get the maximum number of users who log into the system per license over a period of time:

• Hourly License Usage Report for Selected Day
• Daily License Usage Report for Selected Month
• Monthly License Usage Report for Selected Year

You can run the report from My Reports.

Procedure

1. Navigate to My Reports. Search for the reports in the Community tab and System Reports tab by filtering the title, name, or display type.
2. Run the reports.

Example of the Daily License Usage Report

Administrators or DBAs can also execute direct queries against the LICENSE_METRIC table to get a report that is tailored to their specific needs. For example, you can execute a query to get the maximum total user count by day for the year, then sql can be written that is similar to the following, where you can add each license ID in which you're interested:

select TO_CHAR(time_snapshot, 'MM-DD-YYYY') as "Date",
max(users) as "Users",
max(L_3001) as "L3001",
max(L_3002) as "L3002",
max(L_3003) as "L3003",
max(L_3004) as "L3004",
max(L_3006) as "L3006",
...
...
...
from license_metric
where time_snapshot >= TO_DATE('01-01-2022', 'MM-DD-YYYY')
and time_snapshot <= TO_DATE('12-31-2022', 'MM-DD-YYYY')
group by TO_CHAR(time_snapshot, 'MM-DD-YYYY')
order by TO_CHAR(time_snapshot, 'MM-DD-YYYY');