Re: MOST URGENT!!!! IDLE-TIME=0

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 30 Dec 1998 10:18:23 +0100
Message-ID: <3689EFDF.E36D6B79@sybrandb.demon.nl>

Job_queue_refresh_interval is in seconds. This means Oracle is checking every 10 seconds whether there are any jobs to execute. I have seen problems arising by this kind of setting before. Also a refresh rate (of snapshots?) of 1 minute doesn't look very good to me.

Hth,

Sybrand Bakker, Oracle DBA

naveen_arora_at_my-dejanews.com wrote:

> Hi ,
>
> I have faced this problem twice, the idle -time of processor is 0. i am using
> ORACLE 7.3.2, on unix in mult-master configuration, with 3 master sites,
> refresh rate being 1 minute, job_process are 4 on unix machine, with
> shared_size as 40MB, job_refresh_interval as 10. I have observed all
> SNP0,SNP1,SNP2,SNP3 are eating away all CPU.
>
> Thanks for any help.
> naveen
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Wed Dec 30 1998 - 03:18:23 CST