About Database Resident Connection Pooling pt.2

When To Use Database Resident Connection Pooling

oracle Siebel crm training courses malaysia

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

• A large number of client connections need to be supported with minimum memory usage.

• The client applications are similar and can share or reuse sessions.

  Applications are similar if they connect with the same database credentials and use the same schema.

• The client applications acquire a database connection, work on it for a relatively short duration, and then release it.

• Session affinity is not required across client requests.

• There are multiple processes and multiple hosts on the client side.

Advantages of Database Resident Connection Pooling

oracle peoplesoft training courses malaysia

Using database resident connection pooling provides the following advantages:

• Enables resource sharing among multiple middle-tier client applications.

• Improves scalability of databases and applications by reducing resource usage.

Database Resident Connection Pooling and LOGON/LOGOFF Triggers

oracle Linux administration training courses malaysia

LOGON triggers fire for every authentication and every time a new session is created in DRCP.

LOGOFF triggers fire on every log off and when the sessions are destroyed in DRCP. Therefore, a LOGOFF trigger fires when a session is terminated due to an idle time limit.

oracle e business suite training courses malaysia