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

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? Received on Wed Jan 10 2007 - 08:16:17 CST