
Installgen
Features and Benefits
Installgen
Demo Available for download...
Bookmark This Page

CREATE OR REPLACE PROCEDURE admin.pt1
IS
-- script name: pt1 (performance test 1)
-- Features: Consists of a simple loop 1 - 1,000,000 to compare
-- native compiled vs interpreted PLSQL performance
--
-- Usage: set timing on
-- execute admin.pt1
-- alter session set plsql_compiler_flags ='NATIVE';
-- alter procedure admin.pt1 compile;
-- execute admin.pt1
-- alter session set plsql_compiler_flags ='INTERPRETED';
-- alter procedure admin.pt1 compile;
-- execute admin.pt1
--
-- This output file was created by Installgen version 1.38 on Thu Nov 14 17:48:05 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
v_count1 NUMBER := 0;
BEGIN
-- just loop for 1 million times to test performance
FOR loop_index IN 1 .. 1000000
LOOP
v_count1 := v_count1 + 1;
END LOOP;
END pt1;

