Database Connection Monitoring
By default, Oracle Utilities Market Settlements Management uses a common database userid for accessing the information from the connection pools used by the product (through the Universal Connection Pool (UCP)). While this sufficient for execution of the product, it can complicate monitoring individual connections and troubleshooting database issues with individual users or transactions.
It is now possible to show additional details that are inherited from the from the online and Web Services components. The following information is available from the connection and accessible from v$session.
Note: Due to the length limitation on CLIENT_IDENTIFIER, the value will be the authorization identifier not the authentication identifier.
For example, the following database query will return the session ids and the users using then at any time:
SELECT sid, client_identifier, module, client_info, action FROM V$SESSION;
The new information can be used to track sessions using the v$session view, use more advanced features of the database and use other database options.