Subject | Re: AW: AW: [firebird-support] database and structure problem |
---|---|
Author | Gabor Boros |
Post date | 2009-01-20T18:02:22Z |
Hi,
I think you have long running not commited transactions.
Please read this faq http://www.firebirdfaq.org/faq352 and
the Monitoring Tables section
http://www.firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb210-mon of the
Release Notes.
In example with SELECT * FROM MON$TRANSACTIONS you can see all
transactions and when its started etc., with SELECT * FROM
MON$ATTACHMENTS you can see all attachments, connected client
applications etc. Please read the documentation. ;-)
If your app do nothing and you see many transactions this is the problem.
Gabor
Olaf Kluge írta:
I think you have long running not commited transactions.
Please read this faq http://www.firebirdfaq.org/faq352 and
the Monitoring Tables section
http://www.firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb210-mon of the
Release Notes.
In example with SELECT * FROM MON$TRANSACTIONS you can see all
transactions and when its started etc., with SELECT * FROM
MON$ATTACHMENTS you can see all attachments, connected client
applications etc. Please read the documentation. ;-)
If your app do nothing and you see many transactions this is the problem.
Gabor
Olaf Kluge írta:
> Hello,
>
> thanks again for help.
>
> The difference is very large:
>
> Flags: 0
> Checksum: 12345
> Page Size: 4096
> ODS version: 11.1
> Oldest Transaction: 60347
> Oldest Active: 60348
> Oldest Snapshot: 60348
> Next Transaktion: 119652 !!!
> Bumped..:1
> Sequence..:0
> Next att. ID: 42
> Implem. ID: 16
> Shadow Count: 0
> Page buffers: 0
> Next hp: 0
> Dialect: 3
> Erstellt: This day 7:54AM
> Sweep intervall: 20000
>
> Does this difference so great impact on the functioning of the database?
>
>
>
> Regards.
>
> Olaf Kluge