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

DRG-52204: error while registering index

1 Answers  


NZE-28818: No package context provided.

1 Answers  


ORA-32550: Replacement occured despite hint to the contrary

1 Answers  


ORA-22281: cannot perform operation with an updated locator

1 Answers  


ORA-31015: Attempted to insert entry without name

1 Answers  






ORA-12504: TNS:listener was not given the SID in CONNECT_DATA

1 Answers  


ORA-22915: cannot ALTER a nested table's storage table to ADD/MODIFY columns

1 Answers  


ORA-02817: Read failed

1 Answers  


SQL*Loader-00121: Invalid skip_unusable_indexes option

1 Answers  


ORA-28201: Not enough privileges to enable application role 'string'

1 Answers  


CLSR-00506: Unmatched resource name prefix string is specified

1 Answers  


ORA-16700: The standby database has diverged from the primary database.

1 Answers  


Categories