1 alert错误提示:
ORA-01555 caused by SQL statement below (Query Duration=19832 sec, SCN: 0x0000.c40acf06):
Sun Jul 15 06:26:51 2007
select/*+ FIRST_ROWS */ tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay, tab.expiration, tab.retry_count, tab.except
ion_qschema, tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info, tab.state, tab.enq_tid,
tab.step_no, tab.sender_name, tab.sender_address, tab.sender_protocol, tab.dequeue_msgidfrom SMPUSER.QT_MT_OUTBOX tabwhere
q_name = :1 and state = :2order by q_name, state, enq_time, step_no, chain_no, local_order_nofor update skip locked
Sun Jul 15 06:28:23 2007
2 QT_MT_OUTBOX是个队列表
3 功能就是
java程序A 调用过程--入队
java程序B 异步调用过程---出队
是多线程的java程序
请xd们分析下,这种问题怎么解决?
|