Sqlalchemy / Gevent / Cx_oracle Pool Size Stays At 1

I cannot get SQLAlchemy v. 1.3.22 with gevent 21.1.2 and cx_Oracle 8.1.0 to issue more than one query at a time despite the fact that I use a pool size of 50. I am not sure which o

Solution 1:

Add in the top

import greenify

greenify.greenify()
assert greenify.patch_lib("/usr/lib/oracle/19.5/client64/lib/libclntsh.so.19.1")

but adjust the pool size otherwise yo are risking your application getting killed the hard way. You need to test it first which the question provides an excellent script for. See https://github.com/oracle/python-cx_Oracle/issues/126