Hello Vlad, >> When I execute a stored procedure (with or without package, doesn't >> matter), e.g.: >> >> select * from pkg_schema.s_user_tables; >> >> I also see appropriate PREPARE_STATEMENT etc. events for the SELECT >> statement. Whereas when I execute a stored function with e.g.: >> >> select foo(2) from rdb$database; >> >> I only see the EXECUTE_FUNCTION_* events, but none related to the SELECT >> statement. >> >> Is this as designed? > > Of course, not. I see all statement related events: > > 2014-02-22T17:46:27.4320 (2292:02DB3EE0) PREPARE_STATEMENT > A.FDB (ATT_53, SYSDBA:NONE, NONE, <internal>) > (TRA_70, READ_COMMITTED | NO_REC_VERSION | WAIT | READ_WRITE) > > Statement 41: > ------------------------------------------------------------------------------- > select f1(1) from rdb$database > 0 ms > > 2014-02-22T17:46:27.4320 (2292:02DB3EE0) EXECUTE_STATEMENT_START > A.FDB (ATT_53, SYSDBA:NONE, NONE, <internal>) > (TRA_69, CONCURRENCY | WAIT | READ_WRITE) > > Statement 41: > ------------------------------------------------------------------------------- > select f1(1) from rdb$database > > 2014-02-22T17:46:27.4320 (2292:02DB3EE0) EXECUTE_FUNCTION_START > A.FDB (ATT_53, SYSDBA:NONE, NONE, <internal>) > (TRA_69, CONCURRENCY | WAIT | READ_WRITE) > > Function F1: > param0 = integer, "1" > > > 2014-02-22T17:46:27.4320 (2292:02DB3EE0) EXECUTE_FUNCTION_FINISH > A.FDB (ATT_53, SYSDBA:NONE, NONE, <internal>) > (TRA_69, CONCURRENCY | WAIT | READ_WRITE) > > Function F1: > param0 = integer, "1" > > returns: > param0 = integer, "2" > > 0 ms > > 2014-02-22T17:46:27.4320 (2292:02DB3EE0) EXECUTE_STATEMENT_FINISH > A.FDB (ATT_53, SYSDBA:NONE, NONE, <internal>) > (TRA_69, CONCURRENCY | WAIT | READ_WRITE) > > Statement 41: > ------------------------------------------------------------------------------- > select f1(1) from rdb$database > 1 records fetched > 0 ms, 5 fetch(es) > > Table Natural Index Update Insert > Delete Backout Purge Expunge > *************************************************************************************************************** > RDB$DATABASE 1 > > > 2014-02-22T17:46:27.4320 (2292:02DB3EE0) CLOSE_CURSOR > A.FDB (ATT_53, SYSDBA:NONE, NONE, <internal>) > > Statement 41: > ------------------------------------------------------------------------------- > select f1(1) from rdb$database > > > > Could you show me how to reproduce the issue ?
I'm really sorry for wasting your time. I had an exclude filter defined with '%RDB$%', thus it makes sense now that I don't see the expected trace output. Sorry again. Regards, Thomas ------------------------------------------------------------------------------ Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
