You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Submitted by: Robert Gilland (robert.gilland_basx.com.au)
Votes: 1
We are constantly updating our catalogue of stored procedures. However process keeps failing as we get "Object in use" errors. We need to know who has these procedures open so we can disconnect them ( read fire them ) and continue on our merry way. We would like the monitor tables to tell us what nasty people have our objects in use.
The text was updated successfully, but these errors were encountered:
If this is a common occurance, then it seems appropriate that you use the "shutdown" database function to prevent user connections, while you are applying schema updates.
That way you guarantee that the updates will be successful, without the termination/severance costs related to firing staff and the effort in hiring new staff. ;-)
I tend to agree with Sean. If you want to freeze all activity in order to perform a schema upgrade, database shutdown is a proper way to go. Otherwise, monitoring tables will not help much, because as soon as you get a list of "blockers" other sessions may also take a lock on these procedures, so your "kill list" will get outdated immediately.
Also, beware that you need to use WAIT mode for your DML transaction altering the schema, it nearly zeroes a possibility to get "object in use" errors, at least for procedures/triggers.
Submitted by: Robert Gilland (robert.gilland_basx.com.au)
Votes: 1
We are constantly updating our catalogue of stored procedures. However process keeps failing as we get "Object in use" errors. We need to know who has these procedures open so we can disconnect them ( read fire them ) and continue on our merry way. We would like the monitor tables to tell us what nasty people have our objects in use.
The text was updated successfully, but these errors were encountered: