Re: re - posting ODM.DMS_QUEUE_TABLE question

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

DA Morgan wrote:
> dorit wrote:
> > Thank you for your reply .
> >
> > as far as i can tell ( i'm new in the job) we are not using Advanced
> > Queuing.
> > my odm user ( the owner of the table ) status is "locked and expired"
> >
> > and my problem is i see this query running a long time on my database
> > and consuming expensive resource.
> >
> > if i don't need it ( and i don't think i need it ) how can i stop it
> > from running :
> > setting aq_tm_processes=0 ?
> >
> > can i find out why this query is running ?
> >
> >
> > thanks.
> >
> > dorit
>
> Given your status (new in the job) I would suggest you push yourself
> back from the keyboard and not touch anything until you find out what
> is on the server and how it is supposed to work.
>
> If an app is using AQ and you drop that table or muck around with the
> startup parameters you will be unemployed the same day: Or deserve the
> same.
>
> To ask the question "can i find out why this query is running?"
> indicates a serious deficiency in either you skill set and/or your
> knowledge of the system. Starting with platform, operating system,
> version, etc. tell us everything you know about the instance.
> --
> 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
Received on Fri Oct 20 2006 - 15:41:16 CDT