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;
Solved! Go to Solution.
It does not look like it is possible. According to the documentation, "Note: You cannot disable schema locking on map services configured to use the shared instance pool."
It does not look like it is possible. According to the documentation, "Note: You cannot disable schema locking on map services configured to use the shared instance pool."