When developing queries and stored procedures, it is possible to lock up access to the database. this can happen most frequently when autocommit is off, and a transaction is left hanging in a window. If all else fails, the application that is causing the lockup can be identified and forced with: LIST APPLICATIONS; FORCE APPLICATION [...]
Tag Archives: lock