- Do the following to purge the data in the queue table and IOTs
connect / as sysdba
DECLARE
po dbms_aqadm.aq$_purge_options_t;
BEGIN
po.block := FALSE;
DBMS_AQADM.PURGE_QUEUE_TABLE(
queue_table => 'SYS.SYS$SERVICE_METRICS_TAB',
purge_condition => NULL,
purge_options => po);
END;
/
The data in this queue table is transitory, so although it is lost it will soon be replaced.
- Apply the fixes for bug 17831758, bug 18536720 and bug 16204151 and ensure that post-install steps are followed.
All bugs will be resolved in 12.2 when it is available.