pando:

non-realtime statistics is useless to us.
I have no problem to create a trigger like this:

CREATE OR REPLACE TRIGGER {trigger name}
AFTER|BEFORE INSERT OR DELETE OR UPDATE ON {table name}

DECLARE
/*my code*/
BEGIN
END {trigger name};

but the problem is that how can i store the number of DML transactions somewhere? Since I can't issue COMMIT in the trigger body.