Re: Cleanup Data Pump queues

From: Surachart Opun <surachart_at_gmail.com>
Date: Sat, 20 Feb 2010 22:10:50 +0700
Message-ID: <1dacf81e1002200710r71cfdb6ck9b51309ade65f894_at_mail.gmail.com>



KUPC$*
Oracle Creates Queues(service names) During using datapump. service_names should clean up after data pump finished. http://surachartopun.com/2009/11/datapump-with-syssys-servicenames.html

About Queue Name -> I don't see queue (old date) in QUEUE_TABLE table.

Good Luck
Surachart Opun
http://surachartopun.com

On Sat, Feb 20, 2010 at 9:34 PM, LS Cheng <exriscer_at_gmail.com> wrote:

> Hi
>
> From time to time some of my data pump jobs generate queues which are not
> cleanup after some sort of errors or manual abort. This generate some funny
> service names such as SYS$SYS.KUPC$C_1_20100220091129.ONLINE. Sort of
> annoying although not critical.
>
> I have been cleanup the queues using this steps:
>
> SQL> exec dbms_aqadm.stop_queue('KUPC$C_1_20100220091129')
> PL/SQL procedure successfully completed.
>
> SQL> exec dbms_aqadm.stop_queue('KUPC$S_1_20100220091129')
> PL/SQL procedure successfully completed.
>
> SQL> exec dbms_aqadm.drop_queue('KUPC$C_1_20100220091129')
> PL/SQL procedure successfully completed.
>
> SQL> exec dbms_aqadm.drop_queue('KUPC$S_1_20100220091129')
> PL/SQL procedure successfully completed.
>
>
> It works but is this correct? Because I cannot find much information on MOS
> about cleaning up these queues.
>
> TIA
>
> --
> LSC
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Feb 20 2010 - 09:10:50 CST

Original text of this message