Hi, i have sent some DB alert log to oracle global support for diagnosing. In their finding, i need to enable those queue from dequeue based on the error code as ORA-25253
select OWNER, NAME, DEQUEUE_ENABLED from DBA_QUEUES
where DEQUEUE_ENABLED='NO'
I ran above sql in sqlplus but ended up "0" row shown
so, what does it mean by this ? do i need to enable those queue based on this output ?
if i ran select OWNER, NAME, DEQUEUE_ENABLED from DBA_QUEUES
it did show
OWNER NAME DEQUEUE
------------------------------ ------------------------------ -------
SYS AQ$_KUPC$DATAPUMP_QUETAB_1_E NO
SYS AQ$_KUPC$DATAPUMP_QUETAB_2_E NO
SYSMAN MGMT_LOADER_Q YES
SYSMAN AQ$_MGMT_LOADER_QTABLE_E NO
SYSMAN MGMT_PAF_RESPONSE_Q YES
SYSMAN MGMT_PAF_REQUEST_Q YES
SYSMAN AQ$_MGMT_PAF_MSG_QTABLE_2_E NO
SYSMAN AQ$_MGMT_PAF_MSG_QTABLE_1_E NO
SYSMAN MGMT_NOTIFY_INPUT_Q YES
SYSMAN AQ$_MGMT_NOTIFY_INPUT_QTABLE_E NO
SYSMAN MGMT_NOTIFY_Q YES
OWNER NAME DEQUEUE
------------------------------ ------------------------------ -------
SYSMAN AQ$_MGMT_NOTIFY_QTABLE_E NO
SYSMAN MGMT_TASK_Q YES
SYSMAN AQ$_MGMT_TASK_QTABLE_E NO
WMSYS WM$EVENT_QUEUE YES
WMSYS AQ$_WM$EVENT_QUEUE_TABLE_E NO
SYS SYS$SERVICE_METRICS YES
SYS AQ$_SYS$SERVICE_METRICS_TAB_E NO
SYSTEM DEF$_AQERROR YES
SYSTEM AQ$_DEF$_AQERROR_E NO
SYSTEM DEF$_AQCALL YES
SYSTEM AQ$_DEF$_AQCALL_E NO
OWNER NAME DEQUEUE
------------------------------ ------------------------------ -------
SYS AQ$_KUPC$DATAPUMP_QUETAB_E NO
SYS AQ_PROP_NOTIFY YES
SYS AQ$_AQ_PROP_TABLE_E NO
SYS AQ_EVENT_TABLE_Q YES
SYS AQ$_AQ_EVENT_TABLE_E NO
SYS SRVQUEUE YES
SYS AQ$_AQ$_MEM_MC_E NO
SYS ALERT_QUE YES
SYS AQ$_ALERT_QT_E YES
SYS SCHEDULER_FILEWATCHER_Q YES
SYS AQ$_SCHEDULER_FILEWATCHER_QT_E NO
OWNER NAME DEQUEUE
------------------------------ ------------------------------ -------
SYS SCHEDULER$_REMDB_JOBQ YES
SYS AQ$_SCHEDULER$_REMDB_JOBQTAB_E NO
SYS SCHEDULER$_EVENT_QUEUE YES
SYS AQ$_SCHEDULER$_EVENT_QTAB_E NO
37 rows selected.
----------------------------------
pls advise..tq