Re: Cleanup Data Pump queues

From: LS Cheng <exriscer_at_gmail.com>
Date: Sat, 20 Feb 2010 21:07:04 +0100
Message-ID: <6e9345581002201207j2f255116w2fca271825c8a585_at_mail.gmail.com>

Unfortunately the ones I am talking about are not cleaned up (thet is why I am asking if what I am doing is correct!)

When I am dropping the queues I can see in the alert that in background ALTER SYSTEM SET service_names is being run to cleanup the services

Thanks

On Sat, Feb 20, 2010 at 4:10 PM, Surachart Opun <surachart_at_gmail.com> wrote:

> 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 - 14:07:04 CST