---In firebird-support@yahoogroups.com, wrote :
> From time to time, when I try to alter a stored procedure in a
> production database, I get "object in use" error.
Run DDL statement in wait transaction. Better to set some timeout to not wait
too much, but not no-wait
Hi,
From time to time, when I try to alter a stored procedure in a
production database, I get "object in use" error. I was wandering, is
there a way to find the connections (users) that prevent a particular
procedure from being altered?
Querying MON$STATEMENTS is a no-go, no statement
On 25.10.2016 o 10:20, hv...@users.sourceforge.net [firebird-support] wrote:
>> From time to time, when I try to alter a stored procedure in a
>> production database, I get "object in use" error.
> Run DDL statement in wait transaction. Better to set some timeout to not
> wait too much, but
24.10.2016 18:08, 'Gregor Kobler' wrote:
>
> Is it also valid for Server 3.0? Are the roules 4 transaction per byte
> also valid at FB3 ?
Yes.
Dmitry
Hi,
I am trying to figure out the amount of free space within my database, so that
I can detect when I'm nearing exhausting the disk space. I'm using
firebird-v2.5.2.
I know that (total_pages * page_size) = size on disk. This doesn't tell me how
many of those allocated pages are free. If I
25.10.2016 19:03, Bryan Cole bryan.c...@teraview.com [firebird-support] wrote:
>
> I am trying to figure out the amount of free space within my database, so
> that I can
> detect when I'm nearing exhausting the disk space. I'm using firebird-v2.5.2.
Look at DBInfo: