Repgen Features
and Benefits
Repgen
Demo Available for download...
-- script name: repprepcheck
-- Features: Checks the values of the critical init.ora entries required
for
-- replication to work, and prints this information on the command
-- line.
-- NOTE: This file needs to be run and the parameters need to be checked
-- at each master site.
-- Copyright 2002 by .com Solutions Inc.
-- This output file was created by Repgen version 2.2.4 on Fri May 31
13:29:24 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
select 'global_names = ' || value || ' (value should be TRUE)' from
v$parameter where name = 'global_names';
select 'global_name value = ' || global_name || ' (value should be EXACTLY
the same as the Site Name)' from global_name;
select 'job_queue_processes = ' || value || ' (value should be > 0)'
from v$parameter where name = 'job_queue_processes';
-- job_queue_interval is obsolete in Oracle 9.0.1 and higher
select 'job_queue_interval = ' || value || ' (value should > 0 seconds,
and generally 60 seconds is Ok)' from v$parameter where name = 'job_queue_interval';
select 'distributed_transactions = ' || value || ' (value should be
> 1)' from v$parameter where name = 'distributed_transactions';
select 'open_links = ' || value || ' (value should be > 0)' from v$parameter
where name = 'open_links';
select 'parallel_automatic_tuning = ' || value || ' (value should generally
be TRUE - but is not mandatory)' from v$parameter where name = 'parallel_automatic_tuning';
select 'parallel_max_servers = ' || value || ' (value should be > 0)'
from v$parameter where name = 'parallel_max_servers';
select 'aq_tm_processes = ' || value || ' (value should be > 0)' from
v$parameter where name = 'aq_tm_processes';
