Re: JavaProc + Oracle

From: Jack the Ripper <jr_at_entecheco.com>
Date: Tue, 19 Nov 2002 16:34:53 +0200
Message-ID: <ardi4p$och$1@entecheco.com>

> >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.
>

Yes, but the changing of job_queue_interval doesn't solve the problem of breaking for user session when java stored proc is running. Have any idea about this? Received on Tue Nov 19 2002 - 08:34:53 CST