OCI Connection Pool provides an support for Session Multiplexing. From what I understand session multiplexing is having multiple sessions over the same physical connection.

After doing some tests I realize that OCI multiplexes multiple sessions over the same physical connection only when the first session on that connection is IDLE. While it seems logical to not start a new session when the initial one is already active, I fail to understand the actual use of session multiplexing in an web application.

Won't it be very rare that the application requests for a connection and does not use it (i.e. the borrowed connection remains IDLE)?

It would be great if someone could share their experience in using the session multiplexing feature of OCI connection pooling.