prof_sample — Adds a profiling sample to a profile being
in desc varchar ,
in time_spent integer ,
in flag integer );
prof_sample is used to adds a
profiling sample to a profile being accumulated.
The first argument is the name of the sampled section, the times
called and cumulative times will be totaled under this heading. The
second argument is the time in milliseconds. The third argument is
a flag indicating whether the section was successfully executed. 0
indicates success, 1 indicates execute of the statement, 2
indicates fetch on a statement's resultset, 4 indicates error. For
more description of profiling capabilities see the section about
Profiling in Performance tuning part of
A VARCHAR . Name of the sampled
An INTEGER . Time in milliseconds.
An INTEGER . flag indicating whether
the section was successfully executed. 0 - success, 1 - execute of
statement, 2 - fetch on a statement's resultset, 4 - error.