Many databases allow applications to store client information associated with a connection. For example, the following types of information can be useful for database administration and monitoring purposes:

  • Name of the application currently using the connection.
  • User ID for whom the application using the connection is performing work. The user ID may be different than the user ID that was used to establish the connection.
  • Host name of the client on which the application using the connection is running.
  • Product name and version of the driver on the client.
  • Additional information that may be used for accounting or troubleshooting purposes, such as an accounting ID.
Note: Oracle allows you to store additional client information including the action associated with the current module, identifying information about the client, and the name of the current module.