My Oracle Support Banner

refresh_temp_table.sh,TMP_NETACENCU_NT_WIREACBENE is running long (Doc ID 2508298.1)

Last updated on NOVEMBER 10, 2019

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.2 version, Scenarios

/database/db_tools/bin/refresh_temp_table.sh,TMP_NETACENCU_NT_WIREACBENE,TMP_NETACENCU_NT_WIREACBENE_VW,Y,N is running long.

-------
Log:

2019-02-05 15:46:34,561 [main] INFO REFRESH_TEMP_TABLE - Message 265235: Running query TMP_NETACENCU_NT_WIREACBENE
2019-02-05 15:46:34,563 [main] DEBUG REFRESH_TEMP_TABLE - Message 265004: Connecting to database = jdbc:oracle:thin:@ho-fccm-scan.nigeria.firstbank.local:1521/FCCMDB
2019-02-05 15:46:35,141 [main] DEBUG REFRESH_TEMP_TABLE - Message 265006: The SQL is: [CALL P_MNR_TRUNC_TABLE(?,?,?)]
2019-02-05 15:46:35,205 [main] DEBUG REFRESH_TEMP_TABLE - Message 265006: The SQL is: INSERT /*+ APPEND */ INTO pro_ofsaafccm.TMP_NETACENCU_NT_WIREACBENE SELECT * FROM pro_ofsaafccm.TMP_NETACENCU_NT_WIREACBENE_VW

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.