可以使用DBUtils的数据库链接池PooledDB
pip install DBUtils==1.3

import dmPython
from DBUtils.PooledDB import PooledDB

pool = PooledDB(creator=dmPython, mincached=50,maxcached=100, server='192.168.1.118',  port=5236, user='SYSDBA', password='123456789')

conn = pool.connection()
cur = conn.cursor()
SQL = "select username from dba_users"
r = cur.execute(SQL)
r = cur.fetchall()
cur.close()
conn.close()