RE: Lazy dbms_job
- From: "Justin Mitchell" <jmitchell@xxxxxxxxxxx>
- To: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
- Date: Thu, 21 Apr 2005 11:16:03 -0400
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@xxxxxxxxx]=20
Sent: Thursday, April 21, 2005 11:09 AM
To: Justin Mitchell
Cc: jknight@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Lazy dbms_job
Yes, thought about that. Is it not too resource intensive ?=20
rm.
On 4/21/05, Justin Mitchell <jmitchell@xxxxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
