Re: adding delay/pause/sleep inside oracle stored procedure

Frank van Bortel wrote:
> Ed Prochak schreef:

>> jobs wrote:
>>> What's the best way to add a 500 second delay/pause/sleep inside an
>>> oracle stored procedure?
>> WHY?
>>

That's not a joke. I once caught one of America's "premier" consultancies doing this in an Oracle eBusiness Suite install. Found it shortly after they went into a meeting due to end-user complaints about performance and offered up two of their consultants to "tune" the system.

I tuned it with a simple:

set linesize 121

SELECT owner, name, type, line
FROM dba_source
WHERE LOWER(text) LIKE '%sleep%';

Which, by the way, everyone should try on their system. You may find it as amusing as I did.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org