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-01240: too many data files to add in one command

1 Answers  


ORA-02045: too many local sessions participating in global transaction

1 Answers  


ORA-19583: conversation terminated due to error

1 Answers  


NNO-00318: overriding next statistic counter reset, resetting in number seconds

1 Answers  


ORA-16734: Error executing dbms_logstdby.skip_error procedure

1 Answers  






DRG-12432: configuration file string not found or unreadable

1 Answers  


ORA-31671: Worker process string had an unhandled exception.

1 Answers  


ORA-09209: sftget: error reading from file

1 Answers  


ORA-31603: object "string" of type string not found in schema "string"

1 Answers  


RMAN-02005: token too big

2 Answers  


RMAN-08042: channel string: copied standby controlfile

1 Answers  


ORA-29917: cannot lock a table which gets its rows from a collection operand

1 Answers  


Categories