Advanced Oracle PL/SQL Programming with Packages

14.2. Capturing the Start Time

The capture procedure of PLVtmr allows you to capture the start time for a timing session. Its header is:

PROCEDURE capture (context_in IN VARCHAR2 := NULL);

The single argument supplies a context which is associated with this timing session. When you call capture, PLVtmr in turn calls DBMS_UTILITY.GET_TIME to "capture the moment."

The following call to capture starts the timing session and assigns it the name "Calculating Totals":

PLVtmr.capture ('Calculating Totals');