Restart QMon process

Event "Streams AQ: waiting for time management or cleanup tasks" in running state

SELECT event, state, COUNT(*) AS cnt, sum(seconds_in_wait) AS wait_in_seconds
FROM v$session_wait
WHERE event LIKE 'Streams AQ%'
GROUP BY event, state;

select * from GV$QMON_TASKS

select * from GV$QMON_SERVER_STATS

select isdefault from v$parameter where name='aq_tm_processes';

Restart QMon process

show parameter aq_tm_processes

alter system set aq_tm_processes = 0;

alter system set aq_tm_processes = 1;

show parameter aq_tm_processes

alter system reset aq_tm_processes scope=spfile;