ASAP Appears To Fill Tbl_perf_[Asdl|Csdl|Ne|Ne_asdl|Order] Up (Doc ID 757842.1)

Last updated on APRIL 11, 2012

Applies to:

Oracle Communications ASAP - Version: 4.7.1 and later   [Release: 4.7 and later ]
Information in this document applies to any platform.

Symptoms

The ASAP table  Tbl_perf_[Asdl|Csdl|Ne|Ne_asdl|Order] appears to fill up but does not get cleaned up.

CSDL: take approximately 3 minutes
ASDL: take more than 10 minutes

Following messages received:


>>
103814.396:15: LOW:ASC_ocicreate_cmd :607 :ocilib.c
Created PL/SQL statement as follows : begin :retval :=ASP_get_last_csdl(:curs,:sarm); end;
>> 103814.396:15: LOW:ASC_ociparse :522 :ocilib.c
Successfully parsed PLSQL block cursor
>> 104127.387:15: LOW:Perf Mon :1504:perf_mon.c


>>104127.491:15: LOW:ASC_ocicreate_cmd :607 :ocilib.c
Created PL/SQL statement as follows : begin :retval :=ASP_get_last_asdl(:curs,:sarm); end;
>> 104127.491:15: LOW:ASC_ociparse :522 :ocilib.c
Successfully parsed PLSQL block cursor
>> 105151.837:15: LOW:Perf Mon :1386:perf_mon.c
Updated ASDL [A_ALCATEL-SMC_3_REMOVE_SEL_REJECT_SUBSCR] with new performance data.
>>
>>
>>
>>
>>

>>
>>
>>
>>
>>



>>
>>
>>
>>
>>
>>

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms