Connection pool with cx_Oracle

pool_cx_oracle.py

import cx_Oracle

def perform_query(query, bind_variables):
    connection = db_pool.acquire()
    cursor = connection.cursor()
    cursor.execute(query, bind_variables)
    result = cursor.fetchall()
    cursor.close()
    db_pool.release(connection)
    return result

db_pool = cx_Oracle.SessionPool('oracle user', 'oracle pass', 'oracle db', 2, 10, 3)

for i in range(100):
    result = perform_query('SELECT ...', {'var': 'abc'})
    print(result)