Find Oracle table locks - Python script

exe_ORA_query_via_python

import cx_Oracle
con =  cx_Oracle.connect('scott/tiger@IPADDRESS/SID')
print con.version
 
cur = con.cursor()
cur.execute('select a.session_id,a.oracle_username, a.os_user_name, b.owner "OBJECT OWNER", b.object_name,b.object_type,a.locked_mode from (select object_id, SESSION_ID, ORACLE_USERNAME, OS_USER_NAME, LOCKED_MODE from v$locked_object) a, (select object_id, owner, object_name,object_type from dba_objects) b where a.object_id=b.object_id')
 
res = cur.fetchall()
for r in res:
 
 
        print r
 
cur.close()
con.close()