Re: re - posting ODM.DMS_QUEUE_TABLE question

dorit wrote:
> thanks again.
>
> as i said the user is locked (and the tables are empty).
>
>
> >>> deficiency in either you skill set and/or your knowledge of the
> system
> i'll find the solution .... no worry .... thanks you helpful remark !
>
>
>
> dorit

Not trying to be irritable here but did you read what I wrote?

Platform, operating system, Oracle version Connected users?
Are AQ processes running?
init.ora params related to AQ
What other tables are in ODM?
What is the structure of the queue table.

Connect as ODM and run this query:

SELECT object_type, COUNT(*)
FROM user_objects
GROUP BY object_type;

Post the result.

It seems really obvious you have AQ running and that you should leave it alone. How long a query has been running is irrelevant to whether it should be running.

Have you, by any chance, traced it down to the user? Do you know anything about gv$sql? Are you familiar with DBMS_SUPPORT?

Your posts ring alarm bells everywhere: Is there a qualified DBA working with you or elsewhere in your organization?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org