ORA-00600: error in Queue Table SYS.SYS$SERVICE_METRICS_TAB

If this error is coming in Oracle database, then take downtime and do the following:

 Drop the queue table –

exec dbms_aqadm.drop_queue_table( queue_table=>’SYS.SYS$SERVICE_METRICS_TAB’, force => TRUE)

select object_name, object_type from dba_objects where object_name like ‘%SYS$SERVICE_%’;

—-> no rows should be returned.

Follow the below steps to recreate the queue table.

SQL>STARTUP

SQL>alter system enable restricted session;

SQL>@$ORACLE_HOME/rdbms/admin/catproc.sql

SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql

SQL>alter system disable restricted session;