Tracing the Oracle Health Insurance Database Activity
An Oracle Health Insurance application’s middle tier process connects to an Oracle database through a JDBC connection pool. Starting with the 3.18.2 release of Oracle Health Insurance applications, every time an application process gains a connection from the pool, application-related information is set for the following attributes:
-
Module: Name of the currently executing module
-
Action: Name of the currently executing action
-
ClientId: Client identifier
These values appear in the V$SESSION
database view and many Oracle database performance views and often report in trace files.
For various use cases in Oracle Health Insurance applications, the attributes are set as follows:
Use Case | Module | Action |
---|---|---|
OHI HTTP API Resources |
URI path of the OHI Resource |
The HTTP method. |
Task Processing |
Task Types Reference Code |
The task’s subject code. For example, for Claims this is the claim code. |
In all cases, the ClientId
is set to the id of the Oracle Health Insurance user that executes the request.
Setting these values makes it possible to trace, for example:
-
Query execution on behalf of a specific user
-
Task processing for a specific claim
-
Query execution for specific web service requests
Enable Database Tracing
Database tracing based on the attributes from the previous section can be through either of the following methods:
-
Based on the combination of module and action. For example, by calling
DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE
. -
Based on the
ClientId
. For example, by callingDBMS_MONITOR.CLIENT_ID_TRACE_ENABLE
.
Database tracing usage notes:
-
Enable the database tracing for diagnostic purposes only.
-
A database trace writes typically to multiple trace files. Use the
trcsess
tool to collect data into a single file. -
All instances enable tracing and is persistent across restarts. Check enabled traces by executing the following code:
select * from DBA_ENABLED_TRACES
See the Oracle Database documentation for additional information.