Oracle Replication Database Parameters distributed_ transactions global_names job_queue

Our Remote DBA Clients

Oracle Replication Tips by Burleson

Oracle Database Parameters

PARAMETER NAME	DEFAULT VALUE	RECOMMENDED VALUE
distributed_ transactions	.25 * the parameter setting for transactions	Add 5 + 2 per master to the existing value. Note this is obsolete in Oracle9i and later.
global_names	FALSE	global_names must be set to TRUE in each database that will be involved in advanced replication.
job_queue_ processes	0	This parameter must be set to a value of at least one. Higher values will allow more parallel replication of objects. We recommend 3 + 1 per additional master.

This is an excerpt from Oracle Replication By Rampant TechPress (only $19.95). You can click here to order a copy and get instant access to the code depot:

http://www.rampant-books.com/book_2003_2_replication.htm

Need an Oracle Health Check?

Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?

BC Oracle performance guru's can quickly verify every aspect of your Oracle database and provide a complete certification that your database is fully optimized.