Skip to Main Content

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!

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
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2010
Added on Nov 4 2010
2 comments
3,371 views