Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

select count query hangs

User_BH2ZQJun 20 2021 — edited Jun 20 2021

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

Comments
Post Details
Added on Jun 20 2021
2 comments
868 views