Find Shared instance scheam locks

192
0
11-10-2021 02:11 PM
DrewDowling
Occasional Contributor III

I'm trying to track down schema locks coming from map services. I have noticed that shared instances no longer have the check box to "lock database schema". The attached images shows this difference.

However I have determined that the locks are coming from shared instances using the code below. Is there a way to tell shared instances to not lock schemas in the same way as you can with dedicated instances? The shared instance process ID doesn't tell me which map service is causing the lock.

 

SELECT A.SERVER_ID, B.OWNER || '.'|| B.TABLE_NAME "TABLE", A.NODENAME, L.LOCK_TYPE FROM SDE.SDE_PROCESS_INFORMATION A, SDE.SDE_TABLE_REGISTRY B, SDE.SDE_TABLE_LOCKS L
WHERE A.SDE_ID = L.SDE_ID AND L.REGISTRATION_ID = B.REGISTRATION_ID 
ORDER BY NODENAME, SERVER_ID;

 

0 Replies