Check the SCN of applied and how bad the SCN spreads. SELECT * from V$streams_apply_reader;
V. Already existing queues You can use query Dba_queues,dba_queue_tables to check: Sql> Select Owner,queue_table,name from dba_queues where owner= ' strmadmin '; OWNER queue_table NAME ----------------- ------------------------- ------------------ Strmadmin sources_queue_table Sources_queue Strmadmin sources_queue_table Aq$_sources_queue_table_e Sql>select Owner,queue_table,object_type from Dba_queue_tables where owner= ' strmadmin '; OWNER queue_table object_type -------------- --------------------- ------------------ Strmadmin sources_queue_table SYS. Anydata
You can use query Dba_queues,dba_queue_tables to check: Sql> Select Owner,queue_table,name from dba_queues where owner= ' strmadmin '; OWNER queue_table NAME ------------------ --------------------- ---------------- Strmadmin target_queue_table Target_queue Strmadmin target_queue_table Aq$_target_queue_table_e
Ways to delete a queue
exec dbms_aqadm.stop_queue (' source_queue '); exec dbms_aqadm.drop_queue (' source_queue ');
The way I create the queue and delete the queue, as follows SQL code?
|