Loading...
Reload document 
Open in new tab Database Practices
Oracle FLEXCUBE UBS 14.4 Db 19c
Version 1.0
August 2020
Table of Contents
1. TABLE & INDEX PARTITIONING ……………………………………………………………………………………………… 1-1
2. SEQUENCE CACHING ………………………………………………………………………………………………………………… 2-1
3. SCRIPT TO CAPTURE AND LOCK STATISTICS FOR VOLATILE TABLES IN FLEXCUBE
SCHEMA……………………………………………………………………………………………………………………………………………… 3-1
4. FLEXCUBE PERIODIC TABLE MAINTENANCE ……………………………………………………………………….. 4-1
5. FLEXCUBE FUNCTIONALITY RELATED PERFORMANCE CHANGES …………………………………… 5-1
1. Table & Index Partitioning
Table and index partitioning helps to reduce the contention and GC related delays in RAC
environment. Table and index partitioning is mandatory if you have deployed Oracle FLEXCUBE
in RAC database.
Following are the list of tables to be partitioned:
Table Name
Partitioning Type Column name
CFTB_CONTRACT_CHARGES
HASH
CLTB_ACCOUNT_APPS_MASTER
RANGE
BRANCH
CONTRACT_REFERENCE_N
O
BRANCH_CODE,PROCESS_
NO
ACTB_ACCBAL_HISTORY
ACTB_DAILY_LOG
ACTB_HISTORY
ACTB_MONTHLY_TOV_HIST
ACTB_VD_BAL
CATM_CHECK_BOOK
CATM_CHECK_DETAILS
CLTB_ACCOUNT_COMPONENTS
CLTB_ACCOUNT_COMP_BALANCES
CLTB_ACCOUNT_COMP_BAL_BREAK
UP
CLTB_ACCOUNT_COMP_BAL_SUMM
ARY
CLTB_ACCOUNT_COMP_CALC
CLTB_ACCOUNT_COMP_SCH
CLTB_ACCOUNT_EVENTS_ADVICES
CLTB_ACCOUNT_PARTIES
CLTB_ACCOUNT_ROLL_COMP
CLTB_ACCOUNT_SCHEDULES
CLTB_ACCOUNT_UDE_EFF_DATES
CLTB_ACCOUNT_UDE_VALUES
CLTB_ACC_COMPOUNDING_DATES
CLTB_ACC_STCH_PROCESED
CLTB_AMOUNT_PAID
CLTB_AMOUNT_PAID_HISTORY
CLTB_AMOUNT_RECD
CLTB_CALC_DATES
CLTB_DISBR_SCHEDULES
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
BRANCH_CODE
AC_BRANCH
AC_BRANCH
BRANCH_CODE
BRN
BRANCH
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
CLTB_ACCOUNT_EVENTS_DIARY
RANGE
BRANCH_CODE
BRANCH_CODE,PROCESS_
NO
CLTB_EVENT_ENTRIES
RANGE
CLTB_EVENT_ENTRIES_PENDING
LIST
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE,PROCESS_
NO
1-1
Partitioning Type Column name
Table Name
CLTB_EVENT_REMARKS
CLTB_LIQ
CLTB_PROCESSED_REVISIONS
CLTB_RECON
CLTB_REVISION_ACCOUNTS
CLTB_REVN_SCHEDULES
CLTP_ACCOUNT_COMP_BALANCES
CLTP_ACCOUNT_COMP_CALC
CLTP_ACCOUNT_COMP_SCH
CLTP_ACCOUNT_SCHEDULES
CLTP_REVN_SCHEDULES
CSTB_AMOUNT_DUE
CSTB_AUTO_SETTLE_BLOCK
CSTB_CONTRACT
CSTB_CONTRACT_EVENT_LOG
CSTB_CONTRACT_OVD
CSTB_EXT_CONTRACT_STAT
CSTB_MSG_LOG
CSTB_RELATIONSHIP_LINKAGE
DETB_BATCH_MASTER
DETB_JRNL_LOG
DETB_PCTRN
DETB_RTL_TELLER
ELTB_UTIL_TXN_LOG
FBTB_OVD
FBTB_TXNLOG_DETAILS
FBTB_TXNLOG_MASTER
FCT_FACILITY
FCT_FAC_EXP_MAP
FCT_LOAN
FCT_TRACK_EXPOSURE
FCT_UTILS_EXP
FTTB_ACTIVITY_JOURNAL
FTTB_CONTRACT_MASTER
GETB_MAIN_UTILS
GETB_UTILS
GETB_UTILS_LOG
GETB_VD_UTILS
GETH_UTILS
GETM_LIAB
GETM_LIAB_CUST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
HASH
LIST
LIST
HASH
HASH
LIST
HASH
HASH
LIST
LIST
LIST
LIST
HASH
HASH
HASH
HASH
RANGE
RANGE
RANGE
RANGE
RANGE
HASH
HASH
HASH
HASH
LIST
HASH
LIST
HASH
LIST
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
BRANCH_CODE
CONTRACT_REF_NO
ACCOUNT_BR
BRANCH
CONTRACT_REF_NO
CONTRACT_REF_NO,EVEN
T_SEQ_NO,OVD_SEQ_NO
BRANCH_CODE
MSG_ID
REF_NO
BRANCH_CODE
BRANCH_CODE
BRANCH
BRANCH_CODE
MASTER_TXN_ID
SEQ_NO,XREF
XREFID
XREFID
MIS_DATE
MIS_DATE
MIS_DATE
MIS_DATE
MIS_DATE
CONTRACT_REF_NO
CONTRACT_REF_NO
UTIL_ID
USER_REFNO
UTIL_BRN
FACILITY_ID
UTIL_BRN
ID
BRANCH_CODE
1-2
Table Name
Partitioning Type Column name
GLTB_CUST_ACCBREAKUP
GLTB_GL_BAL
GWTB_DEDUPE
GWTB_MSG_IN_LOG
GWTB_MSG_OUT_LOG
ICTB_ACC_PR
ICTB_ACC_PR_HISTORY
ICTB_ADJ_INTEREST
ICTB_ADJ_INTEREST_HISTORY
ICTB_BOOK_ERR
ICTB_CHG_VAL
ICTB_DLY_MSG_OUT
ICTB_DR_INT_DUE
ICTB_ENTRIES
ICTB_ENTRIES_HISTORY
ICTB_IS_VALS
ICTB_ITM_TOV
ICTB_PROBLEM_LOG
ICTB_UDEVALS
ICTB_UDEVAL_ROW
ICTM_ACC
ICTM_CHILDTD_DETAILS
ICTW_ACC_PR
ICTW_BACK_IS_VALS
ICTW_MAKE_ROW
ISTB_CONTRACTIS
ISTB_CONTRACT_DETAILS
ISTB_MSGHO
ISTM_INSTR
MITB_CLASS_MAPPING
MSTB_DLY_MSG_OUT
MSTB_EXT_MSG_OUT
MSTB_MSG_PDE_LOG
MSTB_MSG_STAT
MSTM_MSG_ADDRESS
PCTB_CONTRACT_MASTER
SITB_CONTRACT_MASTER
SITB_CYCLE_DETAIL
SITB_CYCLE_DUE_EXEC
SITB_DLY_MSG_OUT
LIST
LIST
HASH
HASH
HASH
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
LIST
HASH
HASH
LIST
LIST
LIST
LIST
HASH
HASH
HASH
HASH
LIST
HASH
HASH
LIST
HASH
HASH
HASH
HASH
LIST
HASH
LIST
LIST
HASH
BRANCH_CODE
BRANCH_CODE
MSG_REF_NO
MSG_REF_NO
MSG_REF_NO
BRN
BRN
BRN
BRN
BRN
BRN
BRN
BRN
BRN
BRN
BRN
BRN
BRN
BRN
BRN
BRN
BOOK_BRN
COND_KEY
COND_KEY
COND_KEY
CONTRACT_REF_NO
CONTRACT_REF_NO
CONTRACT_REF_NO
BRANCH
UNIT_REF_NO
BRANCH
DCN
DCN
REFERENCE_NO
CUSTOMER_NO
BRANCH_CODE
CONTRACT_REF_NO
BRANCH_CODE
BRANCH_CODE
INSTRUCTION_NO
MSTB_CONTRACT_CHG_ADVICE
CONTRACT_REF_NO
1-3