RE: Lazy dbms_job

From: Justin Mitchell <jmitchell_at_taxwise.com>
Date: Thu, 21 Apr 2005 11:16:03 -0400
Message-ID: <59426D03782DBD42AED3E85C3DAFED833C9947@exch01.utsad.com>

As far as our experience goes, it definitely is not too resource intensive. The only resource we normally lose while using it is time, oddly enough.

According to the docs, it "suspends the session for a given period of time", so I can't imagine it doing anything too naughty.

Justin Mitchell

-----Original Message-----
From: Ranko Mosic [mailto:ranko.mosic_at_gmail.com]=20 Sent: Thursday, April 21, 2005 11:09 AM
To: Justin Mitchell
Cc: jknight_at_concordefs.com; oracle-l_at_freelists.org Subject: Re: Lazy dbms_job

Yes, thought about that. Is it not too resource intensive ?=20 rm.

On 4/21/05, Justin Mitchell <jmitchell_at_taxwise.com> wrote:
> If you want to spare some resources, why not put in a DBMS_LOCK.SLEEP=20
> call to give the database a breather?

>=20

> Justin Mitchell

>=20
>=20

The information contained in this electronic message from Universal Tax Systems, Inc., and any attachments, contains information that may be confidential and/or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of this information is strictly prohibited. If you have received this communication in error, please notify Universal Tax Systems, Inc., immediately by e-mail or by telephone at 706/290-7200, and destroy this communication. Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 21 2005 - 11:21:04 CDT