ORA-24018: STOP_QUEUE on string failed, outstanding
transactions found



ORA-24018: STOP_QUEUE on string failed, outstanding transactions found..

Answer / guest

Cause: There were outstanding transactions on the queue, and
WAIT was set to false, so STOP_QUEUE was unsucessful in
stopping the queue.

Action: Set WAIT to TRUE and try STOP_QUEUE again. It will
hang till all outstanding transactions are completed.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-03287: invalid FREELIST GROUP specified

1 Answers  


ORA-13005: recursive HHCODE function error

1 Answers  


QSM-01084: materialized view, string, has anchor, string, not found in query

1 Answers  


ORA-26523: rpc termination error

1 Answers  


ORA-02040: remote database string does not support two-phase commit

1 Answers  






RMAN-08007: channel string: copied datafilecopy of datafile string

1 Answers  


TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter from SID_DESC

1 Answers  


ORA-16120: dependencies being computed for transaction at SCN string

1 Answers  


NNL-01008: Outbound message contexts allocated: number

1 Answers  


ORA-02214: duplicate BACKUP option specification

1 Answers  


ORA-13339: LRS polygon clipping across multiple rings

1 Answers  


ORA-01247: database recovery through TSPITR of tablespace string

1 Answers  


Categories