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 (<application number>);
The application number can be a comma-separated list.