Re: [Firebird-devel] ODP: SQL profiler
On 09/11/2021 09:15, Roman Simakov wrote: > вт, 9 нояб. 2021 г. в 14:30, Adriano dos Santos Fernandes > : >> >> Currently it's only possible via database triggers making others >> attachments start they own sessions. >> >> >>> It would be nice to have it implemented. >>> >> >> Agree. > > Are you going to do it? > After the refactor (and bug fixes) is complete I would like to take a look. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Request IDs, MON$STATEMENTS and MON$STATEMENT_ID
On 10/11/2021 11:41, Dmitry Yemanov wrote: > 09.11.2021 03:21, Adriano dos Santos Fernandes wrote: >> >> I think all statements should be split in MON$STATEMENTS and >> MON$COMPILED_STATEMENTS. > > What about execute_immediate? Should they be reported only inside > MON$STATEMENTS or also have a record in MON$COMPILED_STATEMENTS but as > not shareable (bound to the current attachment) or be globally shared > but "shortlived" (destroyed when the request is finished)? > Considering that in the future even these statements may be stored in the compiled cache for reuse, I'd say they have no special thing. Also I think the mirroring in MON$STATEMENTS would be only due to compatibility. If new columns should be used and are related to Statement classes, they should only be in MON$COMPILED_STATEMENTS, so all statements (requests) must be in both (or only in MON$COMPILED_STATEMENTS when only prepared but not executing). Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Request IDs, MON$STATEMENTS and MON$STATEMENT_ID
09.11.2021 03:21, Adriano dos Santos Fernandes wrote: I think all statements should be split in MON$STATEMENTS and MON$COMPILED_STATEMENTS. What about execute_immediate? Should they be reported only inside MON$STATEMENTS or also have a record in MON$COMPILED_STATEMENTS but as not shareable (bound to the current attachment) or be globally shared but "shortlived" (destroyed when the request is finished)? Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel