[firebird-support] Re: Which connection causes object in use - is there a way to find that out?

2016-10-25 Thread hv...@users.sourceforge.net [firebird-support]
---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

[firebird-support] Which connection causes object in use - is there a way to find that out?

2016-10-25 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
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

Re: [firebird-support] Re: Which connection causes object in use - is there a way to find that out?

2016-10-25 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
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

[firebird-support] Re: Calculating Transaction Inventory Pages (TIP)

2016-10-25 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
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

[firebird-support] How to estimate free space inside database file

2016-10-25 Thread Bryan Cole bryan.c...@teraview.com [firebird-support]
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

Re: [firebird-support] How to estimate free space inside database file

2016-10-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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: