Re: Turning off RECO

From: Vincent Ventrone <vav_at_mitre.org>
Date: Tue, 06 Jul 1999 08:35:54 -0400
Message-ID: <3781F82A.5514EB@mitre.org>

Doug Cowles wrote:
>
> I have a RECO process running on a non-distributed database.
> Probably a result of installing parallel server? Not sure, didn't do

Set DISTRIBUTED_TRANSACTIONS=0 in the init.ora & restart the sid.

> In addtion, I've got snp01, and snp02. How did these get turned on?
> There are no replication queries or snaphots in the database.. Are

If you want to get rid of these SNP processes set JOB_QUEUE_PROCESSES=0 in the init.ora. Thay are indeed related to the Oracle job queue facility (jobs submitted via the dbms_job package)

Vincent Ventrone    |  The MITRE Corp.
DBA, Dept. R101     |  M/S C020
vav_at_mitre.org       |  202 Burlington Rd.
(781) 271-7048      |  Bedford, MA 01730

Received on Tue Jul 06 1999 - 07:35:54 CDT