Capture and Apply Processes in a RAC
Instance
SQL> show user
USER is "SYS"
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
After the DNYDBA2A is shutdown, the queue
buffers move over to instance DNYDBA2B automatically. Now,
connect to the DNYDBA2B instance and query the owner instance
for the NY1_QUEUE_TABLE queue.
SQL> select instance_name, instance_number
from v$instance ;
INSTANCE_NAME INSTANCE_NUMBER
---------------- ---------------
DNYDBA2B 2
SQL> select QUEUE_TABLE, TYPE, OBJECT_TYPE,
PRIMARY_INSTANCE,
SECONDARY_INSTANCE, OWNER_INSTANCE from
DBA_QUEUE_TABLES
SEE CODE DEPOT FOR FULL SCRIPT
/
