My Oracle Support Banner

Task TMP_NETACENCU_NT_CUACADDR was failing (Doc ID 2851668.1)

Last updated on NOVEMBER 28, 2022

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.7 version, Scenarios

ACTUAL BEHAVIOR
---------------
Task TMP_NETACENCU_NT_CUACADDR was failing.

refresh_temp_table.log
2022-02-10 23:16:21,766 [main] INFO REFRESH_TEMP_TABLE - Message 265235: Running query TMP_NETACENCU_NT_CUACADDR
...
2022-02-11 09:05:39,704 [main] FATAL REFRESH_TEMP_TABLE - Message 265001: Error - java.sql.SQLException: Error in P_MNR_TRUNC_TABLE procedure : ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
2022-02-11 09:07:30,798 [main] INFO REFRESH_TEMP_TABLE - Message 265235: Running query TMP_NETACENCU_NT_CUACADDR

 

AWR report has below informaition.

 

Impact is 1.04 active sessions, 60.23% of total activity.
---------------------------------------------------------
The PGA was inadequately sized, causing additional I/O to temporary
tablespaces to consume significant database time.
The value of parameter "pga_aggregate_target" was "2048 M" during the analysis
period.

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.