Re: ORDS connection pooling

Ahh thank you Jeff that sounds like exactly what I was looking for. We are currently on ORDS 19.1 so I will be looking to upgrade here soon.

Thanks!

On Thu, Sep 24, 2020 at 9:25 AM Jeff Smith <jeff.d.smith_at_oracle.com> wrote:

> 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