Re: JavaProc + Oracle

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 19 Nov 2002 11:26:47 +0100
Message-ID: <lb4ktugvslni14qtsphorett6jpn0k5nre@4ax.com>

On Tue, 19 Nov 2002 10:09:03 +0200, "Jack the Ripper" <jr_at_entecheco.com> wrote:

>These procedures are called every from JOBS every 10
>seconds.

That is just *way too often*. Oracle usually just can't cope with it!

BTW your job_queue_interval is not set to 60 seconds incidentally? That would also explain a lot of problems. However, don't set your job_queue_interval to 10 secs, you won't be able to shutdown the instance normally.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Nov 19 2002 - 04:26:47 CST