Audit number on temporary id3/15/2024 ![]() Nevertheless, an audit/trace does not replace the monitoring tables, because with the monitoring tables, the user can query a snapshot of the current state of a database, whereas an audit/trace can be compared with a sequential stream of logged statements. It is also possible to save filtered data as a trace log file. Firebird 3 log_function_start/log_function_finishĪnalysis of large trace logs: The main idea is to retrieve only necessary items from a trace log file using the Grid View mode with applied filter criteria.START/FINISH of stored procedures and triggers.PREPARE/START/FINISH/FREE of SQL statements.START/ COMMIT/ ROLLBACK of transactions. ![]() Some of the supported statements include: Engine activity logging for a specified period of time (be it hours or a whole day) for later analysis.Interactive trace of specified activity in specified database(s).Two different kinds of traces can be performed: user traces and a system audit. (This feature is unfortunately not included in the free IBExpert Personal Edition.) This feature enables you to look inside the Firebird engine and log various events for real-time analysis. This menu item supports the Firebird 2.5 Trace and audit services, initially developed from the TraceAPI contributed by Nickolay Samofatov that he had developed for Red Soft Database, a commercial product based on Firebird's code.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |