Capture and Apply Processes in a RAC
Instance
Use the following SQL queries to view the
instance details and buffers details at the DNYDBA2A instance:
SQL> select * from v$active_instances ;
INST_NUMBER INST_NAME
-----------
--------------------------------------------
1 nytms-a:DNYDBA2A
2 nytms-b:DNYDBA2B
SQL> select instance_name, instance_number
from v$instance ;
INSTANCE_NAME INSTANCE_NUMBER
---------------- ---------------
DNYDBA2A 1
SQL> select QUEUE_TABLE, TYPE, OBJECT_TYPE,
PRIMARY_INSTANCE,
SECONDARY_INSTANCE, OWNER_INSTANCE from
DBA_QUEUE_TABLES
SEE CODE DEPOT FOR FULL SCRIPT
/
Primry Secndry Owner
QUEUE_TABLE TYPE OBJECT_TYPE
Insta Insta Insta
------------------- ------- ------------
-------- --------- ------
NY1_QUEUE_TABLE OBJECT
SYS.ANYDATA 0 0 1
