My Oracle Support Banner

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

Last updated on SEPTEMBER 11, 2019

Applies to:

Oracle Communications ASAP - Version 4.7.1 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.