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

LPX-00274: can't import node type

1 Answers  


PCC-00047: Unterminated comment/string constant beginning near line number in file string

1 Answers  


TNS-04064: The number of CMCTL sessions exceeds MAX_CMCTL_SESSIONS.

1 Answers  


NZE-28772: invalid file ID

1 Answers  


ORA-39068: invalid master table data in row with PROCESS_ORDER=string

1 Answers  






NNL-00538: stop|shutdown [<server_list>] : stop one or more Names servers

1 Answers  


ORA-38444: statistics do not exist for the expression set

1 Answers  


RMAN-06034: at least 1 channel must be allocated to execute this command

1 Answers  


ORA-37001: You have one or more attached but unupdated analytic workspaces.

1 Answers  


SQL*Loader-00800: %s specified and ignored

1 Answers  


ORA-24180: invalid transformation expression, the transformation expression does not evaluate to the target type/attribute

1 Answers  


RMAN-06427: recovery catalog already exists

1 Answers  


Categories