View oracledb locks made by unified

[sharad1126]

Impact of the new feature We don't have some place where we can find oracledb locks. It makes investigating dynamo locks or others difficult to identify.

Is your feature request related to a problem? Please describe. Since 2020-04-30_01:10:15 the transferor module says there is a dynamo lock. Benedikt told that it is due to a lock in oracle db which apparently exists since last 13 hours.

Describe the solution you'd like It would be great to keep a check and may be put in mongo or somewhere the locks created for oracledb from the Unified/assignSchema.py which is used by Unified/assignSession.py

Additional context @z4027163 @vlimant fyi

[sharad1126]

waiting on dynamo {u'message': u'Locked', u'data': {u'depth': 6, u'lock_time': 1588199602, u'service': None, u'user': u'dynamo'}, u'result': u'OK'}

[sharad1126]

262 @z4027163 there is some info related to this here.