hi,
I'm running below code to find count(*) with big logic in python cx_Oracle from AWS EC2. In oracle client and aqua studio returns result in 14 mins but python code taking so much time(1 hr) still not returning output nor throwing any error.
Note: small query returning very properly.
conn = cx_Oracle.connect(user=user, password=password, dsn=dsn_tns)
cursor.execute(query)
result = cursor.fetchall();
If you give any clue or idea that would be great help. I'm struggling past one week
Installed cx_Oracle
python3 -m pip install cx_Oracle --upgrade
Installed cx_Oracle-8.2.1-cp37-cp37m-manylinux1_x86_64.whl
Regards
Suresh