VB and VBA Users Source Code: Timing ORACLE stored procedures

VB/VBA Source Code
Timing ORACLE stored procedures

By:	Andrew Baker
Email (spam proof):	Email the originator of this post
Date:	Friday, July 30, 2004
Hits:	1765
Category:	Database/SQL/ADO

Article:
Below is a simple example of how to repeatedly call an ORACLE stored procedure for timing purposes: DECLARE start_date DATE := SYSDATE; input_param VARCHAR2(10) := 'TRD'; output_param NUMBER(17); BEGIN FOR i IN 1 .. 10000 LOOP MyStoredProc(input_param, output_param); END LOOP; DBMS_OUTPUT.PUT_LINE('START: ' \|\| TO_CHAR(start_date,'SSSSS')); DBMS_OUTPUT.PUT_LINE('END: ' \|\| TO_CHAR(SYSDATE,'SSSSS')); END;
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder