Metering the number of Oracle Database concurrent sessions
To retrieve detailed information about the number of Oracle Database concurrent user sessions that run on the computers in your environment, use the Get Oracle Concurrent Sessions Number fixlet. When the data is imported to BigFix Inventory, it is displayed in the Resource Utilization report.
Before you begin
LocalSystem
user on
Windows, or as the database instance owner on Linux, AIX or Solaris. Ensure that this user has the
Oracle SYSDBA
privilege. About this task
BigFix Inventory supports metering of Named User Plus
license consumption. Run this task to retrieve information about the current number of concurrent
sessions, and the high water mark value of concurrent sessions for Oracle Databases that are
installed on the computers in your infrastructure. These values are individually retrieved for each
database instance with the following SQL
query.
SELECT sessions_highwater, sessions_current FROM v$license;
The
database instance must be running when the task is executed. Otherwise, the values of high water
mark, and current number of sessions equal 0 in the report. After you run this task, the data is
collected on a daily basis by default, to preserve the high water mark value that is reset after
each database instance restart.For more information about the Oracle licenses, see: Oracle Database Licensing.
Procedure
- Log in to the BigFix console.
- In the navigation bar, click .
- In the upper right pane, select Get Oracle Concurrent Sessions Number.
- Optional:
To enable debug logging, select the Debug mode check box.
The information is logged in the script_trace_sessions.txt file that is, by default, in the following location.
/var/opt/BESClient/LMT/ORACLE
C:\Program Files (x86)\BigFix Enterprise\BES Client\LMT\ORACLE
- Optional: On Unix endpoints, you can change the folder in which the temporary script used by the fixlet is created. By default, it is Oracle instance owner's default folder. In case there is a security policy in place which forbids keeping executable scripts in this folder, you can select a subfolder of /tmp folder.
- To run the task, click Take Action. On the Target tab, select computers from which you want to retrieve the information, and click OK.
- Ensure that the software scans are enabled, and run automatically. If not, run the software scan manually. Select the Resource Utilization Scan.
- Ensure that the scan results are automatically uploaded. If not, upload the results to the BigFix server manually.
- To make the data available in BigFix Inventory, wait for the scheduled import of data, or run it manually.
Results
The retrieved data about the Oracle database concurrent sessions is listed in the Resource
Utilization report. To view the data, log in to BigFix Inventory, and go to
.