Storing client information
- Last Updated: October 28, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Oracle Database Wire Protocol 8.0
- Documentation
Your application can store client information associated with a connection. The following table shows the driver connection options that your application can use to store client information and where that client information is stored for each database. See "Connection Option Descriptions" for a description of each option.
| Option | Description | Location |
|---|---|---|
| Accounting Info (AccountingInfo) | Additional information that may be used for accounting or troubleshooting purposes, such as an accounting ID | CLIENT_INFO value in the V$SESSION table. |
| Action (Action) | The current action within the current module. | ACTION value in the V$SESSION table. |
| Application Name (ApplicationName) | Name of the application currently using the connection | CLIENT_IDENTIFIER attribute. In addition, this value is also stored in the PROGRAM value in the V$SESSION table. |
| Client Host Name (ClientHostName) | Host name of the client on which the application using the connection is running | MACHINE value in the V$SESSION table. |
| Client ID (ClientID) | Additional information about the client | CLIENT_IDENTIFIER value in the V$SESSION table. |
| Client User (ClientUser) | User ID for whom the application using the connection is performing work | OSUSER value in the V$SESSION table. |
| Module (Module) | The name of a stored procedure or the name of the application | MODULE value in the V$SESSION table. |
| Program ID (ProgramID) | Product name and version of the driver on the client | PROCESS value in the V$SESSION table. |