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

ORA-24018: STOP_QUEUE on string failed, outstanding transactions found
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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:45

ORA-24018：STOP_QUEUE 字符串失败，找到未完成的事务,
.原因：队列上有未完成的事务，WAIT设置为false，因此STOP_QUEUE在停止队列时失败。,
.操作：将WAIT设置为TRUE，然后再次尝试STOP_QUEUE。它将挂起，直到所有未完成的交易完成。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题