DGS VA - Account Mapper FSI_KICOND_ACCNT_MAP Partition Has Stale Stats
(Doc ID 2824738.1)
Last updated on DECEMBER 05, 2021
Applies to:
Oracle Financial Services Data Governance for North America Regulatory Reporting - Version 8.0.8 and laterInformation in this document applies to any platform.
Goal
As part of all MDRMs testing, faced temp space issue while loading data origin table from mapper table due to stale stats in FSI_KICOND_ACCNT_MAP partitions.
FSI_KICOND_ACCNT_MAP Range Partitions
Partition Highvalue
P236 237
P237 238 – This partition(P237) has stale stats due to gather stats performed using high value which 238 and we don’t have any data for 238 runskey.
P239 240
P240 241 -- This partition(P240) has stale stats due to gather stats performed using high value which 241 and we don’t have any data for 241 runskey
Failed Task –
Batch - EONEINFO_E1_DGS_ACCT_MAPPER_INSERT
Task10 - Task to run the final Mapper Insert Function - FN_ACCT_FINAL_MAPPER_INSERT
Error : "Data Origin table insertion got failed for run_skey 237 Error ORA-12801: error signaled in parallel query server P013, instance danuxb7020db01.xxxxxx.com:u70200031 (1)
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP"
Solution
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
| Goal |
| Solution |
| References |