If you are running classic on linux maybe you can kill the lock manager
process as well as the other firebird processes. Just a guess though, I
am not sure if it will work...

-steve

Tom Conlon wrote:

>
> Hi,
>
> Whilst testing some queries is there a way to clear the DB (and
> perhaps OS) cache *completely*.
>
> I've tried disconnecting from the database and restarting the service,
> but the first 'cold' run of certain queries still run quick - unless
> I completely reboot the machine.
>
> Also, is there a way of seeing the plan to be used *without* actually
> going onto to run the query against a large table?
>
> Thanks,
> Tom
>
>