> > Am I right to think that I need to create a process to run the command on a
> regular basis (every 5 secs?) to find what objects locks are waiting for?
>
> Yes. But we're still guessing in the dark

<SL> That's fine, that is at least a path to investigate...

>, the reason of the slowdown could be completely unrelated to the lock manager (e.g. bad plans,
> undesired access to MON$ tables inside triggers, whatever else).

<SL> We only have 1 process which access MON$ tables, it is a job that runs every 5 minutes to report on long running SQL statements, none of our triggers reference MON$ structures.

<SL> The only thing that we use often is GET/SET RDB$Context variables...


Sean