Re: why is my database running : select from ODM.DMS_QUEUE_TABLE
From: dorit <maromdo_at_yahoo.ca>
Date: 23 Oct 2006 11:41:07 -0700
Message-ID: <1161628867.533220.162300_at_m73g2000cwd.googlegroups.com>
> 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 Mon Oct 23 2006 - 20:41:07 CEST
Date: 23 Oct 2006 11:41:07 -0700
Message-ID: <1161628867.533220.162300_at_m73g2000cwd.googlegroups.com>
thanks !
i found the following metalink note 297551.1.
>
> 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 Mon Oct 23 2006 - 20:41:07 CEST