RE: ORDS connection pooling

There is connection pooling…as ORDS_PUBLIC_USER

Each call then proxy connects as the schema owner…that’s probably what you’re seeing.

There’s an option in newer ORDS where connections can be re-used for performance reasons.

See the ‘Performance of REST APIs’ section in the release notes for 20.2

https://www.oracle.com/tools/ords/ords-relnotes-2021.html

From: Jeff Chirco <backseatdba_at_gmail.com> Sent: Thursday, September 24, 2020 11:24 AM To: oracle-l-freelist <oracle-l_at_freelists.org> Subject: ORDS connection pooling

I am new to using ORDS, currently have one service in production and I am noticing in our audit trail that the schema account logs on and off for each call. 

Is there a way to have connection pooling as I imagine this service will get called very frequently in the future.

Thanks,

Jeff

--
http://www.freelists.org/webpage/oracle-l