SQL> commit; select * from mon$statements where mon$attachment_id=68;

MON$STATEMENT_ID                1726832
MON$ATTACHMENT_ID               68
MON$TRANSACTION_ID              <null>
MON$STATE                       0
MON$TIMESTAMP                   <null>
MON$SQL_TEXT                    0:16
select rdb$db_key from doc_list where  id = ? and ( ? is null or exists( select id from v_add_invoice_to_stock  v where v.id = ? ))
MON$STAT_ID                     29

MON$STATEMENT_ID                1726831
MON$ATTACHMENT_ID               68
MON$TRANSACTION_ID              <null>
MON$STATE                       0
MON$TIMESTAMP                   <null>
MON$SQL_TEXT                    0:18
select id from v_add_invoice_to_stock  where id >= ? order by id rows 1
MON$STAT_ID                     30

MON$STATEMENT_ID                1726830
MON$ATTACHMENT_ID               68
MON$TRANSACTION_ID              <null>
MON$STATE                       0
MON$TIMESTAMP                   <null>
MON$SQL_TEXT                    0:1a
select max(id)+0.5 from v_add_invoice_to_stock
MON$STAT_ID                     31

MON$STATEMENT_ID                1726829
MON$ATTACHMENT_ID               68
MON$TRANSACTION_ID              <null>
MON$STATE                       0
MON$TIMESTAMP                   <null>
MON$SQL_TEXT                    0:1c
select min(id)-0.5 from v_add_invoice_to_stock
MON$STAT_ID                     32

MON$STATEMENT_ID                1726828
MON$ATTACHMENT_ID               68
MON$TRANSACTION_ID              633739
MON$STATE                       1
MON$TIMESTAMP                   2014-07-11 18:53:04.2640
MON$SQL_TEXT                    0:1e
execute block returns( invoice_id bigint, total_lines int, total_invoice_qty int, res_ok int, res_err int )
as
   declare v_this dm_dbobj;
begin
    v_this = 'isql:sp_add_invoice_to_stock';
    --execute procedure sp_add_to_perf_log(v_this||':exists?');
    if ( exists( select * from v_add_invoice_to_stock ) ) then
    begin
      --execute procedure sp_add_to_perf_log(v_this||':exists?');

      execute procedure sp_add_to_perf_log(v_this||':run_sp');
      select
        min(p.doc_list_id)
        ,count(*)
        ,sum(p.qty)
        ,min(p.res_ok)
        ,min(p.res_err)
      from  sp_add_invoice_to_stock  p   -- iter # 13
           --~~~~~~~~~~~~~~~~~~~~~~~~
      into invoice_id, total_lines, total_invoice_qty, res_ok, res_err;
      suspend;

      execute procedure sp_add_to_perf_log(v_this||':run_sp', null,'doc_id='||invoice_id);
   end
   else
   begin
      --execute procedure sp_add_to_perf_log(v_this||':exists?', null,'no rows in view');
   end
end
MON$STAT_ID                     33

MON$STATEMENT_ID                8394
MON$ATTACHMENT_ID               68
MON$TRANSACTION_ID              <null>
MON$STATE                       0
MON$TIMESTAMP                   <null>
MON$SQL_TEXT                    <null>
MON$STAT_ID                     34

MON$STATEMENT_ID                8393
MON$ATTACHMENT_ID               68
MON$TRANSACTION_ID              <null>
MON$STATE                       0
MON$TIMESTAMP                   <null>
MON$SQL_TEXT                    <null>
MON$STAT_ID                     35

MON$STATEMENT_ID                8392
MON$ATTACHMENT_ID               68
MON$TRANSACTION_ID              <null>
MON$STATE                       0
MON$TIMESTAMP                   <null>
MON$SQL_TEXT                    <null>
MON$STAT_ID                     36

  enabled true
#  log_sweep true
  log_errors true

  ####################   A C H T U N G  ##############
  time_threshold 0
  connection_id 68
  ####################################################

  log_connections true
  log_transactions true

  log_statement_prepare true
  log_statement_start true
  log_statement_free true
  log_trigger_start true
  log_procedure_start true

  log_statement_finish true
  log_procedure_finish true
  log_trigger_finish true

#  print_plan true
  print_perf true
  max_sql_length 16384
  max_log_size 9999999999

2014-07-11T20:01:50.6250 (6216:0x7f16ff0a3018) EXECUTE_PROCEDURE_START
	oltp25 (ATT_68, SYSDBA:NONE, NONE, TCPv4:192.168.43.96)
	C:\MIX\firebird\fb25\bin\isql.exe:2488
		(TRA_633739, CONCURRENCY | NOWAIT | READ_WRITE)

Procedure FN_OPER_RETAIL_RESERVE:

2014-07-11T 20:01:50.6250  (6216:0x7f16ff0a3018) EXECUTE_PROCEDURE_FINISH
	oltp25 (ATT_68, SYSDBA:NONE, NONE, TCPv4:192.168.43.96)
	C:\MIX\firebird\fb25\bin\isql.exe:2488
		(TRA_633739, CONCURRENCY | NOWAIT | READ_WRITE)

Procedure FN_OPER_RETAIL_RESERVE:
      0 ms

2014-07-11T 20:01:51.1580  (6216:0x7f16ff0a3018) EXECUTE_PROCEDURE_START
	oltp25 (ATT_68, SYSDBA:NONE, NONE, TCPv4:192.168.43.96)
	C:\MIX\firebird\fb25\bin\isql.exe:2488
		(TRA_633739, CONCURRENCY | NOWAIT | READ_WRITE)

Procedure FN_OPER_RETAIL_RESERVE:

2014-07-11T20:01:51.1580 (6216:0x7f16ff0a3018) EXECUTE_PROCEDURE_FINISH
	oltp25 (ATT_68, SYSDBA:NONE, NONE, TCPv4:192.168.43.96)
	C:\MIX\firebird\fb25\bin\isql.exe:2488
		(TRA_633739, CONCURRENCY | NOWAIT | READ_WRITE

oel64   Tue Jul 15 22:57:38 2014
        /opt/fb30trnk/bin/fbguard: /opt/fb30trnk/bin/firebird terminated abnormally (-1)



oel64   Tue Jul 15 22:57:38 2014
        /opt/fb30trnk/bin/fbguard: guardian starting /opt/fb30trnk/bin/firebird



oel64   Tue Jul 15 22:57:45 2014
        Sweep is started by SWEEPER
        Database "oltp30"
         OIT 192249 , OAT 192250,  OST 152759 , Next 221145


oel64   Tue Jul 15 22:58:05 2014
        Sweep is finished
        Database "oltp30"
        OIT 221145, OAT 221595, OST 221195, Next 224359


oel64   Tue Jul 15 23:00:42 2014
        /opt/fb30trnk/bin/fbguard: /opt/fb30trnk/bin/firebird terminated abnormally (-1)



oel64   Tue Jul 15 23:00:42 2014
        /opt/fb30trnk/bin/fbguard: guardian starting /opt/fb30trnk/bin/firebird



oel64   Tue Jul 15 23:00:46 2014
        Sweep is started by SWEEPER
        Database "oltp30"
         OIT 227402,  OAT 227403,  OST 222170 , Next 237566


oel64   Tue Jul 15 23:01:03 2014
        Sweep is finished
        Database "oltp30"
        OIT 237566, OAT 237873, OST 237603, Next 240283