Q:

Query taking infinte time

This is my code and query is going in a infinite loop without any error or exception
import cx_Oracle
ip=''
port=''
sid=''
dns_tns=cx_Oracle.makedsn(ip,port,sid)
con = cx_Oracle.connect('username','password',str(dns_tns))
cursor = con.cursor()
print("start")
B={'APP_NAME': 'Hello', 'ISSUE_NAME': 'SP_164', 'ISSUE_TYPE': 'CR', 'DEVELOPER': 'username','TESTER': '','RELEASE_NO': '4.0', 'EST_DATE': '2018-10-10', 'ACT_DATE': '2018-10-10',\
  'DETECTED_PHASE': '',  'ISSUE_TRACKING_TOOL': 'SHAREPOINT','ID': 11}
sql_update = "UPDATE ISSUE SET ISSUE_TRACKING_TOOL = :ISSUE_TRACKING_TOOL,APP_NAME = :APP_NAME,\
RELEASE_NO = :RELEASE_NO,ISSUE_TYPE = :ISSUE_TYPE,DEVELOPER = :DEVELOPER,TESTER = :TESTER,\
ISSUE_NAME = :ISSUE_NAME,DETECTED_PHASE = :DETECTED_PHASE ,EST_DATE = TO_DATE(:EST_DATE, 'YYYY/MM/DD') \
,ACT_DATE = TO_DATE(:ACT_DATE, 'YYYY/MM/DD') WHERE ID = :ID"
cursor.execute(sql_update,B)
print("done")
con.commit()
con.close()

A:

It is possible that you are experiencing the result of a lock taking place by another session. You can check the dba_locks view to see if your session is being blocked by another session, and which one it is.

