Re: Slow package execution for testing

From: Andrew Babb <andrewb_at_mail.com>
Date: Tue, 23 Mar 1999 10:41:16 +0800
Message-ID: <36F6FF4C.274BB2A1@mail.com>

You could use DBMS_LOCK.SLEEP routine, which as the package suggests, causes the application to goto sleep for a set period of time (in Seconds), but while this happens, the CPU is not being used.

The only other option I can think off, is to use a FOR LOOP that queries the database ie DUAL a number of times.

Andrew

Jim wrote:

> We call pl/sql packages from a (currently) single threaded database engine.
> We want to test our wizy new multi-threaded jobber against some slow
> running batch jobs but we will need to simulate package execution times of
> up to 10 minutes.
> Is there anyway to get a pl/sql package to wait a pre-set length of time
> or, failing that, have it do something relatively simple but still
> intensive?
> Thanks in advance
> Jim
Received on Mon Mar 22 1999 - 20:41:16 CST