Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

replication_dependency_tracking turned off

user8610659Nov 4 2010 — edited Nov 4 2010
Hi all,

I am a newbie to Oracle 10g database administration. I require your help to interpret few details from the alert log.
I have noticed the following lines in the alert log every time when my database starts.

Sun Feb 21 14:40:57 2010
SMON: enabling tx recovery
Sun Feb 21 14:40:57 2010
Database Characterset is UTF8
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 8
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=10874
Sun Feb 21 14:40:59 2010
Completed: ALTER DATABASE OPEN

OS: HP-UX nlscijj0 B.11.23 U ia64 0020851230 unlimited-user license
Oracle version : 10.2.0.4
Application that runs on Oracle database : SAP

Here are my queries:

a) I have noticed that the parameter replication_dependency_tracking set to true when queried from sqlplus. But i get an alert like "replication_dependency_tracking turned off (no async multimaster replication found)" in the alert log.
What does this alert mean? What does this signify?

b) We are planning to set replication_dependency_tracking to false at the database. What will be outcome/consequnce of setting this parameter (replication_dependency_tracking ) to false?

Please clarify me on the above queries.

Thanks in advance,

with regards,
Ashok

Comments

1. The message says that although replication dependency tracking is enabled, it's being turned off because asynchronous multimaster replication is not in use. Ignore this message, it's harmless.
2. Your database will lose ability to do parallel propagation. If you are not planning to use replication, you can safely set this parameter to false.
CKPT
HI,

are you using any replication? if yes it will turn on


REPLICATION_DEPENDENCY_TRACKING [TRUE/FALSE] <TRUE>
This parameter specifies that dependency tracking for read/write operations to the database is turned on.
when ever instance startup & shutdown all the parameter will be reviewed.


check http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams182.htm#sthref563


this is informational. you can ignore.

Thanks
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 2 2010
Added on Nov 4 2010
#general-database-discussions
2 comments
3,141 views