14.2 Capturing the Start Time

Chapter 14
PLVtmr: Analyzing Program Performance
 

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


14.1 Toggling the Timer14.3 Retrieving and Displaying the Elapsed Time

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



Advanced Oracle PL. SQL Programming with Packages
Advanced Oracle Pl/Sql: Programming With Packages (Nutshell Handbook)
ISBN: B00006AVR6
EAN: N/A
Year: 1995
Pages: 195
Authors: Steven Feuerstein, Debby Russell
BUY ON AMAZON

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net