Flexcube Table Space Consumption Is More
(Doc ID 2941171.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Banking Treasury Management - Version 14.5.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 14.5.0.0.0 version, Production Support-SET
ACTUAL BEHAVIOR
---------------
Flexcube Table space consumption is more
Below tables are heaviest table , could you please check these table growth and suggest how it can be controlled
FCUBSPROD MSTB_DLY_MSG_IN_HIST 22G
FCUBSPROD ICTB_ICALC_STMT 14 G
FCUBSPROD MSTB_DLY_MSG_IN_HIST 22 G
FCUBSPROD ICTB_ICALC_STMT 14 G
FCUBSPROD ACTB_HISTORY 12 G
FCUBSPROD ISTB_CONTRACTIS 11 G
FCUBSPROD SPERRORLOG 6.625 G
FCUBSPROD MSTB_STP_MSG 5 G
FCUBSPROD MSTB_REPAIR_STAT_REPORT 5 G
FCUBSPROD MSTB_TR_STP_MSG 5 G
FCUBSPROD IFTB_EVRY_INFO_HISTORY 4 G
FCUBSPROD MSTB_EXT_ARCHIVE_OUT 4 G
PQTB_QUEUE_REQ_LOG – 11G
STTB_RECORD_LOG_BKP – 11G
STTB_RECORD_LOG_VWCHG - 11
MSTB_DLY_MSG_OUT -18 G
STTB_RECORD_LOG – 19G
MSTB_TR_EXT_MSG_OUT -19G
MSTB_EXT_MSG_OUT -20G
MSTB_TR_ARCHIVE_OUT -26G
MSTB_ARCHIVE_OUT -30 G
MSTB_EXT_ARCHIVE_OUT – 31G
GWTB_MSG_OUT_HISTORY -84 G
GWTB_MSG_OUT_LOG -9 G
EXPECTED BEHAVIOR
-----------------------
Table space consumption should not exceed all of a sudden
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Verify the available table space
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, table space consumption is more
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 |
| References |