Identity-based connection pooling allows applications to use a JDBC connection with a specific DBMS credential based on the end user application by pooling physical connections.
To enable identity-based connection pooling for a JDBC data source:
Note: Set Client ID On Connection and Enable Identity Based Connection Pooling are mutually exclusive. If you think you need both mechanisms to pass security credentials in your application environment, create separate data sources -- one for with Set Client ID On Connection and one with Enable Identity Based Connection Pooling.