Advanced Oracle PL/SQL Programming with Packages

Advanced Oracle PL/SQL Programming with PackagesSearch this book
Previous: 14.1 Toggling the TimerChapter 14
PLVtmr: Analyzing Program Performance
Next: 14.3 Retrieving and Displaying the Elapsed Time
 

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');


Previous: 14.1 Toggling the TimerAdvanced Oracle PL/SQL Programming with PackagesNext: 14.3 Retrieving and Displaying the Elapsed Time
14.1 Toggling the TimerBook Index14.3 Retrieving and Displaying the Elapsed Time

The Oracle Library Navigation

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference