Support #13384
[SCP ID :##6567##] : Housekeeping Procedure
| Status: | Closed - End of life cycle | Start date: | January 06, 2023 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | MY RIB | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:-
Below are total num_rows for main table in IB. Kindly advise on procedure to housekeep the table.
Schema : BVUSERPRD
Tables : 10 of 455
SCHEMA_NAME
TABLESPACE_NAME
TABLE_NAME
NUM_ROWS
BVUSERPRD
USERS
IB_RECEIPT_DETAILS
19,814,040
BVUSERPRD
USERS
IB_USER_ACTIVITY
7,000,256
BVUSERPRD
USERS
IB_TRANSACTION_HISTORY
3,075,068
BVUSERPRD
BVUSERPRD_DATA
SMS_TRIGGERS
2,561,810
BVUSERPRD
USERS
IB_RPT_LIST
2,190,641
BVUSERPRD
USERS
BV_CAT_VS_REF_TMP
2,090,289
BVUSERPRD
USERS
SMS_TABLE
2,023,136
BVUSERPRD
BVUSERPRD_DATA
SMS_TABLE_ACRHIVE
1,979,743
BVUSERPRD
USERS
IB_SMS_NOTIFICATION
1,925,768
BVUSERPRD
BVUSERPRD_DATA
IB_FRAUD_DETECTION_HISTORY
811,741
Schema : BIBL
Tables : 10 of 36
SCHEMA_NAME
TABLESPACE_NAME
TABLE_NAME
NUM_ROWS
BIBL
USERS
BIB_RECEIPT_DETAILS
2,474,658
BIBL
USERS
BIB_USER_TRANSACTION
278,987
BIBL
USERS
BIB_USER_ACTIVITY
147,232
BIBL
USERS
BIB_COMPANY_TRANSACTION
141,624
BIBL
USERS
BIB_FTT_TRANSFER
139,123
BIBL
USERS
BIB_TRNX_APPROVER_RULES
125,641
BIBL
USERS
BIB_APPROVER_STATUS
125,463
BIBL
USERS
CST_USER_ACTIVITY
31,072
BIBL
USERS
KFH_FOREX_RATES
21,246
BIBL
USERS
MK_LOG
5,080
Schema : BIB
Table : 10 of 78
SCHEMA_NAME
TABLESPACE_NAME
TABLE_NAME
NUM_ROWS
BIB
USERS
BIB_RECEIPT_DETAILS
4,241,006
BIB
USERS
BIB_USER_ACTIVITY
679,804
BIB
USERS
BIB_USER_TRANSACTION
518,910
BIB
USERS
BIB_COMPANY_TRANSACTION
289,282
BIB
USERS
BIB_BULK_PAYMENT_DETAIL
240,967
BIB
USERS
BIB_APPROVER_STATUS
194,420
BIB
USERS
BIB_TRNX_APPROVER_RULES
170,500
BIB
USERS
BIB_INTER_TRANSFER
144,330
BIB
USERS
IBG_BULK
129,663
BIB
USERS
CST_USER_ACTIVITY
115,393
BIB
USERS
INTRABANK_BULK
99,166
Schema:FPX
Tables : 10 of 26
SCHEMA_NAME
TABLESPACE_NAME
TABLE_NAME
NUM_ROWS
FPX
FPX_DATA
FPX_PAGE_STATUS
1,022,981
FPX
FPX_DATA
FPX_AR_ORDERLIST
460,524
FPX
FPX_DATA
FPX_AR_MAIN
457,313
FPX
FPX_DATA
FPX_NR
405,915
FPX
FPX_DATA
FPX_NC
405,915
FPX
FPX_DATA
FPX_DAC_MAIN
291,545
FPX
FPX_DATA
FPX_DACA_MAIN
280,811
FPX
FPX_DATA
FPX_DACA_ORDERLIST
278,646
FPX
FPX_DATA
FPX_SR_ORDERLIST
273,700
FPX
FPX_DATA
FPX_SR_MAIN
273,558
Schema: IBG
Tables : 10 of 38
SCHEMA_NAME
TABLESPACE_NAME
TABLE_NAME
NUM_ROWS
IBG
USERS
IBG_CREDIT
832,508
IBG
USERS
IBG_RFI
832,358
IBG
USERS
IBG_ENTRY
566,171
IBG
USERS
IBG_OFI
561,606
IBG
IBG_DATA
IBG_CREDIT_29032016_2
164,186
IBG
IBG_DATA
IBG_CREDIT_29032016
164,156
IBG
IBG_DATA
IBG_RFI_29032016_2
164,036
IBG
IBG_DATA
IBG_RFI_29032016
164,006
IBG
IBG_DATA
IBG_ENTRY_29032016_2
136,289
IBG
IBG_DATA
IBG_ENTRY_29032016
136,283
Schema : NBPS
Tables : 10 of 22
SCHEMA_NAME
TABLESPACE_NAME
TABLE_NAME
NUM_ROWS
NBPS
NBPS_DATA
NBPS_CHANNEL_CALL_1_RESPONSE
73,613
NBPS
NBPS_DATA
NBPS_MYCLEAR_VALIDATE_REQUEST
73,611
NBPS
NBPS_DATA
NBPS_CHANNEL_CALL_1_REQUEST
73,611
NBPS
NBPS_DATA
NBPS_MYCLEAR_VALIDATE_RESPONSE
73,603
NBPS
NBPS_DATA
NBPS_CHANNEL_CALL_2_REQUEST
48,522
NBPS
NBPS_DATA
NBPS_MYCLEAR_NOTIFY_REQUEST
47,322
NBPS
NBPS_DATA
NBPS_OFF_US_REQUEST
46,696
NBPS
NBPS_DATA
NBPS_CHANNEL_CALL_2_RESPONSE
46,601
NBPS
NBPS_DATA
NBPS_OFF_US_RESPONSE
46,597
NBPS
NBPS_DATA
NBPS_MYCLEAR_NOTIFY_RESPONSE
45,584
History
#1
Updated by Zahir Abd Latif over 1 year ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- Assignee changed from Hafizudin MD to Zahir Abd Latif
- % Done changed from 0 to 100
Hafiz, Jan 12, 2023:-
Please get the Housekeeping document via below path //10.20.8.35/internet banking/20230112_housekeeping
#2
Updated by Zahir Abd Latif over 1 year ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
Issue closed in SCP.