EscVector wrote:
> DA Morgan wrote:
>> 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?
>>>>
>>> To "solve the performance problems" for a hefty hourly fee?
>>> To "protect" from being fired?
>> 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
>
> Do we need to guess who it was? Isn't that fraud?
It is in my opinion but I'll not say which of the consultancies as they
hire rapid dogs as attorneys. ;-)
--
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
Received on Wed Jan 10 2007 - 10:49:17 CST