![]() See also my answer on How to capture Firebird SQL queries? on Stack Overflow (as you already found). In addition, there are tools that act like a proxy for Firebird, allowing you to trace activity that way, for example FBScanner. Tooling included with Firebird is rather basic and low level, and you may want to look at third party tools that simplify access to this trace facility. For details see Trace and Audit Services in the Firebird 2.5 release notes, and the article Audit and Trace Services in Firebird 2.5 by Thomas Steinmaurer. The unions between non-recursive members may be of. Recursive members are linked to each other and to their non-recursive neighbour by UNION ALL operators. The non-recursive member(s) must be placed before the recursive member(s). It can be either be configured by an administrator to run server side, or users can do limited tracing of their own sessions remotely (users with administrator rights have more access). A recursive (self-referencing) CTE is a UNION which must have at least one non-recursive member, called the anchor. The trace facility, which allows you to get information on activity in a database. Note that content of monitoring tables are stable within a transaction, so to refresh it, you will have to commit and start a new transaction. ![]() For example MON$STATEMENTS provides the currently running statements. ![]() ![]() The monitoring tables, which provide a snapshot of activity on the server. Firebird has two distinct options for monitoring:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |