Re: re - posting ODM.DMS_QUEUE_TABLE question

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 Received on Fri Oct 20 2006 - 13:59:50 CDT