About Proxy Resident Connection Pooling

Proxy resident connection pooling uses Proxy Resident Connection Pool that can be configured using Oracle Connection Manager in Traffic Director Mode. Proxy resident connection pooling provides high availability, security, and performance for database clients.

oracle database training courses malaysia

A database client that is based on any of the following technologies can use proxy resident connection pooling to connect to a database instance – Oracle Call Interface (OCI), Java Database Connectivity (JDBC), Oracle Data Provider for .NET (ODP.Net), Open Database Connectivity (ODBC), Pro*C, Pro*COBOL, PHP OCI8 extension, Node.js node-oracledb driver, Python cx_Oracle, ROracle, Ruby-oci8, Perl DBD::Oracle, or Oracle C++ Call Interface (OCCI).

oracle cloud infrastructure training courses malaysia

When to Use Proxy Resident Connection Pooling

Proxy resident connection pooling is useful when multiple clients access a database and when any of the following apply:

• A large number of client connections need to be supported using fewer number of connections to a database.

• A database connection needs to be shared across middle tier connection pools.

• More than 64K sessions need to be supported (when shared servers cannot be used as they have a limit of 64K sessions).

• High availability needs to be supported for older clients that do not support Transparent Application Failover (TAF) and Oracle RAC, or the clients that do not use Oracle Database Resident Connection Pooling (DRCP) or Fast Application Notification (FAN) or Application Continuity (AC).

nodejs training courses malaysia

Advantages of Proxy Resident Connection Pooling

Using proxy resident connection pooling provides the following major advantages:

• Improved high availability (planned and unplanned)

• Improved database security

• Database connection multiplexing

MySQL database training courses malaysia