Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Too Many Requests Error

I have a MaxLimit set to 100, but I am getting a "Too Many Requests" error with only two concurrent ORDS REST service callers (i.e., I should be using no more that two connections concurrently). The callers, however, have a high request generation rate for a long period of time and request response time is very short. What appears to be happening is the request rate is higher than the connection reclamation rate and I eventually exhaust the connection pool with only two concurrent callers (each new call appears to require the creation of a new connection). I may be using a new access token on each call, but I do not have the details on that point. So, in short, is it possible to exhaust the connection pool with far fewer concurrent processes than MaxLimit if the request rate is high enough? Is it possible to reuse connections rather than create new ones on subsequent calls? Is it possible to accelerate the reclamation of connections?

Comments
Post Details
Added on Dec 14 2022
0 comments
1,543 views