Quiescence - Definition - Oracle Replication

Q.  What do you mean by Quiescence?
- Published on 27 Jul 15

a. Act of suspending DML activity for all tables in a given replication group
b. Act of suspending DML activity for selected tables in a given replication group
c. Act of granting DML activity for selected tables in a given replication group
d. Act of granting DML activity for all tables in a given replication group

ANSWER: Act of suspending DML activity for all tables in a given replication group
 

    Discussion

  • Nirja Shah   -Posted on 18 Sep 15
    - Quiescence is the act of suspending DML activity for all tables in a given replication group.

    - This is required in order to perform certain administrative tasks on objects in a replication group, such as altering a table.

    - The Oracle built-in package procedure call that quiesces a replication group is DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)