Re: why is my database running : select from ODM.DMS_QUEUE_TABLE

From: SR <srng_at_goawaynms-sys-ltd.demon.co.uk>
Date: Fri, 20 Oct 2006 21:37:23 +0100
Message-ID: <ehbc1g$lg2$1$8300dec7_at_news.demon.co.uk>


maromdo_at_yahoo.ca wrote:
> version 9.2.0.1
> windows 2000
>
> my database is running the following :
>
> select q_name, state, delay, expiration, rowid, msgid, dequeue_msgid,
> chain_no, local_order_no, enq_time, enq_tid, step_no, priority,
> exception_qschema, exception_queue, retry_count, corrid,
> time_manager_info, sender_name, sender_address, sender_protocol from
> ODM.DMS_QUEUE_TABLE where time_manager_info <= :1 and state != :2
> for update skip locked
>
> i couldn't find any info about ODM.DMS_QUEUE_TABLE table.
>
> can someone help me with this issue ....
>
> thanks .
>
> dornit
>

[Quoted] Sounds like an AQ query - I know that the "skip locked" clause is an undocumented trick Oracle use for AQ. Could you not look at the session running the query and trace back from there - could be one the queue managers running it. Received on Fri Oct 20 2006 - 22:37:23 CEST

Original text of this message