Oracle Live SQL - Script: Fragmentation

Statement 1

CREATE TABLE TB_FRAGMENT_REPORT  
(	TYPE VARCHAR2(10 CHAR),  
	SEGMENT_NAME VARCHAR2(30 CHAR),  
	RECLAIMABLE_SPACE_MB VARCHAR2(5 CHAR),  
	ALLOCATED_SPACE_MB VARCHAR2(6 CHAR),  
	USED_SPACE_MB VARCHAR2(6 CHAR),  
	PCT_FRAGMENTATION VARCHAR2(3 CHAR) 
)

Table created.

Statement 2

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX30PK','12','33','21','35')

1 row(s) inserted.

Statement 3

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_AP_BILL_ACC','265','2021','1756','13')

1 row(s) inserted.

Statement 4

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_AP_CARD_NO','365','2063','1698','18')

1 row(s) inserted.

Statement 5

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_AP_CS_CD_NO','316','1092','776','29')

1 row(s) inserted.

Statement 6

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_AP_PRIMARY_ACC','276','2022','1746','14')

1 row(s) inserted.

Statement 7

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_AP_PRINT_FLG','37','303','266','12')

1 row(s) inserted.

Statement 8

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_AP_TXN_POST_DT','164','1344','1180','12')

1 row(s) inserted.

Statement 9

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_AUD_INT_REC','10436','49203','38767','21')

1 row(s) inserted.

Statement 10

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_CUSTOM_TRANS_AER_SEQ_IMPL','18757','111559','92802','17')

1 row(s) inserted.

Statement 11

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_EM_CS_UPLD_ID','433','1665','1232','26')

1 row(s) inserted.

Statement 12

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_GROUP_NUMBER','12','52','40','23')

1 row(s) inserted.

Statement 13

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_LAST_PWDS_LOGIN_MASTER','86','378','292','23')

1 row(s) inserted.

Statement 14

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_MC_CARD_ID','87','691','604','13')

1 row(s) inserted.

Statement 15

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_MODIFIED_ON','156','2080','1924','7')

1 row(s) inserted.

Statement 16

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_RTM_TB_CARD_REQ_GRP_STAT_1','13','114','101','11')

1 row(s) inserted.

Statement 17

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_RWRDS_UIFD','877','1095','218','80')

1 row(s) inserted.

Statement 18

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_RWRD_CARDID','14','51','36','28')

1 row(s) inserted.

Statement 19

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_SOW_AUDIT_PK','706','3665','2959','19')

1 row(s) inserted.

Statement 20

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_AUDIT_SECURITY_MAIN','9979','43879','33900','23')

1 row(s) inserted.

Statement 21

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_CL_DOC_DETAILS_10','36','101','65','35')

1 row(s) inserted.

Statement 22

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_CL_DOC_DETAILS_11','35','133','98','26')

1 row(s) inserted.

Statement 23

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_CL_DOC_DETAILS_2','36','121','85','30')

1 row(s) inserted.

Statement 24

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_CL_DOC_DETAILS_3','26','78','52','33')

1 row(s) inserted.

Statement 25

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_CL_DOC_DETAILS_4','30','120','91','25')

1 row(s) inserted.

Statement 26

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_CL_DOC_DETAILS_5','37','139','101','27')

1 row(s) inserted.

Statement 27

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_CL_DOC_DETAILS_6','17','112','96','15')

1 row(s) inserted.

Statement 28

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_CL_DOC_DETAILS_7','12','44','32','27')

1 row(s) inserted.

Statement 29

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_CL_DOC_DETAILS_8','14','49','35','28')

1 row(s) inserted.

Statement 30

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_CL_DOC_DETAILS_9','28','81','53','34')

1 row(s) inserted.

Statement 31

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_CL_STATISTICS_EOD','12','181','169','7')

1 row(s) inserted.

Statement 32

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_CL_TBR_MANIFEST_1','13','102','89','13')

1 row(s) inserted.

Statement 33

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_CL_TBR_MANIFEST_2','62','310','248','20')

1 row(s) inserted.

Statement 34

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_EMAIL_MULTILANG','16','46','30','35')

1 row(s) inserted.

Statement 35

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_EMAIL_OUTBOUND_1','20','97','77','21')

1 row(s) inserted.

Statement 36

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_GCMS_DET_RPT_CCN','41','119','78','34')

1 row(s) inserted.

Statement 37

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_GCMS_DET_RPT_CNO','12','51','39','23')

1 row(s) inserted.

Statement 38

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_GCMS_DET_RPT_GUI','13','63','50','20')

1 row(s) inserted.

Statement 39

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_GCMS_DET_RPT_ISC','20','50','30','40')

1 row(s) inserted.

Statement 40

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_GCMS_DET_RPT_ISU','14','41','27','35')

1 row(s) inserted.

Statement 41

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_GCMS_DET_RPT_REG','32','86','54','37')

1 row(s) inserted.

Statement 42

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_GCMS_DET_RPT_UST','11','56','45','19')

1 row(s) inserted.

Statement 43

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_OLAM_MAIL_EXCE_KEY_CAT','12','47','35','25')

1 row(s) inserted.

Statement 44

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_OLAM_MNT_HIST_1','74','491','417','15')

1 row(s) inserted.

Statement 45

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_OLAM_MNT_HIST_2','42','183','141','23')

1 row(s) inserted.

Statement 46

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_RTM_ALERT_INBOUND_1','30','198','168','15')

1 row(s) inserted.

Statement 47

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_STATUS_HIST_FK_CARD_REQ','12','204','192','6')

1 row(s) inserted.

Statement 48

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_TRANSACTION','13319','79671','66352','17')

1 row(s) inserted.

Statement 49

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TB_UNIT_1','11','137','126','8')

1 row(s) inserted.

Statement 50

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TRANS_OTHR_CORP_POST_DT','17866','80845','62980','22')

1 row(s) inserted.

Statement 51

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TRANS_OTHR_MEMO_POST_DT','12930','57539','44609','22')

1 row(s) inserted.

Statement 52

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_TRANS_POST_DT','10500','42303','31803','25')

1 row(s) inserted.

Statement 53

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IDX_USER_COMPANY_1','129','1218','1089','11')

1 row(s) inserted.

Statement 54

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX1_TB_CUST_TRANSACTION','9791','28616','18826','34')

1 row(s) inserted.

Statement 55

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX1_TB_TRANSACTION','13177','88694','75517','15')

1 row(s) inserted.

Statement 56

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX2_TB_CUSTOM_STATEMENT','2579','12604','10025','20')

1 row(s) inserted.

Statement 57

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX2_TB_CUST_TRANSACTION','14544','42413','27869','34')

1 row(s) inserted.

Statement 58

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX3_TB_CUSTOM_STATEMENT','1617','7764','6147','21')

1 row(s) inserted.

Statement 59

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX3_TB_TRANSACTION','6842','32398','25556','21')

1 row(s) inserted.

Statement 60

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX4_TB_CUSTOM_STATEMENT','2226','9063','6837','25')

1 row(s) inserted.

Statement 61

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX5_TB_CUSTOM_STATEMENT','1945','9058','7114','21')

1 row(s) inserted.

Statement 62

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX6_TB_CUSTOM_STATEMENT','1132','3608','2475','31')

1 row(s) inserted.

Statement 63

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_ADDR_ZIPCODE','60','218','158','27')

1 row(s) inserted.

Statement 64

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_AP_TXN_BILL_CURRENCY','82','990','908','8')

1 row(s) inserted.

Statement 65

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_AP_TXN_SRC_CURRENCY','82','987','905','8')

1 row(s) inserted.

Statement 66

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_BOUNCEDRPT_CORRELATION_ID','57','57','0','100')

1 row(s) inserted.

Statement 67

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_CARDST_CARD_ID','32','6137','6105','1')

1 row(s) inserted.

Statement 68

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_CLD_FK_LOGIN_MASTER','21','152','132','14')

1 row(s) inserted.

Statement 69

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_CP_FK_ACCOUNT_NUMBER','22','202','180','11')

1 row(s) inserted.

Statement 70

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_CRDPAY_REF_NUM','62','187','124','33')

1 row(s) inserted.

Statement 71

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_FK_TB_AUDIT_MST','6247','28306','22059','22')

1 row(s) inserted.

Statement 72

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_LD_FK_LOGIN_MASTER','17','246','229','7')

1 row(s) inserted.

Statement 73

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_MCL_GEN_TIC_TXN','403','1349','946','30')

1 row(s) inserted.

Statement 74

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_TB_AP_CARD_BALANCE_TOT','3049','19106','16057','16')

1 row(s) inserted.

Statement 75

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_TB_AP_CARD_EPP_DET','1383','7845','6462','18')

1 row(s) inserted.

Statement 76

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_TB_CM_STMT_ACCESSED','19','105','86','18')

1 row(s) inserted.

Statement 77

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_TB_CUST_TRANSACTION','24851','113808','88957','22')

1 row(s) inserted.

Statement 78

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_TB_EM_CARD_BALANCE_TOT','20361','74514','54153','27')

1 row(s) inserted.

Statement 79

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_TB_EM_CARD_EPP_DET','10379','38314','27935','27')

1 row(s) inserted.

Statement 80

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_TB_LINE_ITEM_TRANSACTIO','6787','54129','47342','13')

1 row(s) inserted.

Statement 81

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_TB_TRANS_OTHER_ACCT_NBR','9017','41057','32040','22')

1 row(s) inserted.

Statement 82

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_TCP_CARD_ID','28','137','108','21')

1 row(s) inserted.

Statement 83

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_TC_ACCTYPEID','11','182','171','6')

1 row(s) inserted.

Statement 84

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_TRAN_CARD_ID','5648','27833','22186','20')

1 row(s) inserted.

Statement 85

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_TXN_DIVERTED_CARD_NBR','8806','41371','32565','21')

1 row(s) inserted.

Statement 86

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_UA_FK_ALERT_MASTER','143','886','743','16')

1 row(s) inserted.

Statement 87

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_UA_FK_LOGIN_MASTER','234','1287','1053','18')

1 row(s) inserted.

Statement 88

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_UC_CARD_NO','25','251','226','10')

1 row(s) inserted.

Statement 89

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_UC_FK_LOGIN_MASTER','120','984','864','12')

1 row(s) inserted.

Statement 90

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_UC_FK_USER_COMPANY','119','851','732','14')

1 row(s) inserted.

Statement 91

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_UD_EMAIL_ID','60','284','224','21')

1 row(s) inserted.

Statement 92

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_UE_FK_ENTITLEMENT_MASTER','4601','48703','44103','9')

1 row(s) inserted.

Statement 93

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_UE_FK_LOGIN_MASTER','10626','45507','34882','23')

1 row(s) inserted.

Statement 94

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_UH_FK_REK_HIERARCHY','81','490','409','16')

1 row(s) inserted.

Statement 95

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_UH_FK_UNIT_ID','121','780','659','15')

1 row(s) inserted.

Statement 96

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_UNIT_CMP_ROLE','177','1108','931','16')

1 row(s) inserted.

Statement 97

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_UR_FK_LOGIN_MASTER','118','983','865','12')

1 row(s) inserted.

Statement 98

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_UR_FK_ROLE1','108','733','625','15')

1 row(s) inserted.

Statement 99

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_USER_ALERTS_STATUS','169','858','689','20')

1 row(s) inserted.

Statement 100

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','IX_USER_HIER_FK_ROLE','81','485','404','17')

1 row(s) inserted.

Statement 101

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','PK_EM_MCL_CARDACCEPTOR','828','3113','2285','27')

1 row(s) inserted.

Statement 102

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','PK_EM_MCL_FINANCIALTRANSACTION','802','3098','2297','26')

1 row(s) inserted.

Statement 103

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','PK_TB_ALERT_INVOICE_GENR','19','52','33','37')

1 row(s) inserted.

Statement 104

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','PK_TB_ALERT_PAYMENT_GENR','19','124','106','15')

1 row(s) inserted.

Statement 105

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','PK_TB_AP_CARD_BALANCE_TOT','3832','24097','20265','16')

1 row(s) inserted.

Statement 106

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','PK_TB_AP_CARD_STATEMENT','314','1108','794','28')

1 row(s) inserted.

Statement 107

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','PK_TB_AP_CARD_TRANSACTION','835','4729','3894','18')

1 row(s) inserted.

Statement 108

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','PK_TB_AUDIT_SECURITY','33','7153','7120','0')

1 row(s) inserted.

Statement 109

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','PK_TB_BOUNCE_EMAIL_TRACK','16','16','0','100')

1 row(s) inserted.

Statement 110

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','PK_TB_EM_CARD_BALANCE_TOT','34585','103784','69199','33')

1 row(s) inserted.

Statement 111

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','PK_TB_EM_CARD_EPP_DET','18241','54687','36446','33')

1 row(s) inserted.

Statement 112

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','PK_TB_EM_CARD_TRANSACTION','4441','17592','13151','25')

1 row(s) inserted.

Statement 113

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','PK_TB_USER_ENTITLEMENTS','246','40180','39935','1')

1 row(s) inserted.

Statement 114

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','SYS_C006799','34','220','186','15')

1 row(s) inserted.

Statement 115

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','SYS_C006801','44','252','208','17')

1 row(s) inserted.

Statement 116

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','SYS_C006803','125','544','419','23')

1 row(s) inserted.

Statement 117

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','SYS_C006807','41','247','206','16')

1 row(s) inserted.

Statement 118

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','SYS_C006809','11','61','50','17')

1 row(s) inserted.

Statement 119

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','SYS_C006810','2444','11300','8856','22')

1 row(s) inserted.

Statement 120

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','SYS_C006819','159','687','528','23')

1 row(s) inserted.

Statement 121

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','SYS_C006825','7540','45749','38209','16')

1 row(s) inserted.

Statement 122

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','SYS_C006826','355','1928','1573','18')

1 row(s) inserted.

Statement 123

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','SYS_C006828','2039','3565','1526','57')

1 row(s) inserted.

Statement 124

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','SYS_C006888','4596','23565','18969','20')

1 row(s) inserted.

Statement 125

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','SYS_C006889','1162','6376','5214','18')

1 row(s) inserted.

Statement 126

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','SYS_C007030','14','2566','2552','1')

1 row(s) inserted.

Statement 127

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_ACCOUNT_ALT_UIFID','10','13','3','81')

1 row(s) inserted.

Statement 128

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_ACCOUNT_AUTH_UIFID','2236','2757','521','81')

1 row(s) inserted.

Statement 129

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_ACCOUNT_UIFID','113','320','207','35')

1 row(s) inserted.

Statement 130

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_CARD_COMPANY_UIFID','14','17','4','79')

1 row(s) inserted.

Statement 131

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_CARD_EXTENSION_UIFID','3591','9664','6073','37')

1 row(s) inserted.

Statement 132

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_CARD_FLEET_EXTENSION_UI','342','452','110','76')

1 row(s) inserted.

Statement 133

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_CARD_STATEMENT_UIFID','115','6072','5957','2')

1 row(s) inserted.

Statement 134

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_CAR_RENTAL_LINE_ITEM_UI','97','507','410','19')

1 row(s) inserted.

Statement 135

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_CCMS_MAINTAIN_RESPONSE_PK','14','775','761','2')

1 row(s) inserted.

Statement 136

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_COMPANY_UIFID','14','18','4','79')

1 row(s) inserted.

Statement 137

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_DELIVERY_FAILURE_RPT','16','16','0','99')

1 row(s) inserted.

Statement 138

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_FLEET_LINE_ITEM_UIFID','127','653','526','19')

1 row(s) inserted.

Statement 139

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_FLEET_TABLE_UIFID','13','15','2','87')

1 row(s) inserted.

Statement 140

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_LINE_ITEM_UIFID','8538','54516','45978','16')

1 row(s) inserted.

Statement 141

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_LODGING_LINE_ITEM_UIFID','465','1988','1523','23')

1 row(s) inserted.

Statement 142

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_LOGIN_MASTER_IX','58','175','117','33')

1 row(s) inserted.

Statement 143

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_MCCG_CARD_UIFID','3781','5355','1574','71')

1 row(s) inserted.

Statement 144

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_MCC_GROUP_UIFID','45','53','8','85')

1 row(s) inserted.

Statement 145

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_MERCHANT_UIFID','1125','4510','3385','25')

1 row(s) inserted.

Statement 146

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_TRANSACTION_UIFID','6538','26091','19553','25')

1 row(s) inserted.

Statement 147

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','TB_TRAVEL_LINE_ITEM_UIFID','1741','6985','5244','25')

1 row(s) inserted.

Statement 148

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','XAK1TB_LINE_ITEM','740','91651','90911','1')

1 row(s) inserted.

Statement 149

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','XAK1TB_MERCHANT','3389','18125','14736','19')

1 row(s) inserted.

Statement 150

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','XCARD_UPDATED','85','427','341','20')

1 row(s) inserted.

Statement 151

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','XCARD_UPDATED_IMPORT_FILE_ID','201','451','250','45')

1 row(s) inserted.

Statement 152

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','XIE1TB_FLEET_TABLE','19','23','4','84')

1 row(s) inserted.

Statement 153

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','XIE1TB_TRANSACTION','19858','85193','65334','23')

1 row(s) inserted.

Statement 154

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','XIE1_TB_AUDIT','6852','66081','59228','10')

1 row(s) inserted.

Statement 155

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('INDEX','XIE_TB_TSYS_REC_50','28','80','52','35')

1 row(s) inserted.

Statement 156

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('TABLE','TB_LINE_ITEM','429','245988','245559','0')

1 row(s) inserted.

Statement 157

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('TABLE','TB_LOGIN_MASTER','249','795','546','31')

1 row(s) inserted.

Statement 158

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('TABLE','TB_MCCG_CARD','248','3598','3350','7')

1 row(s) inserted.

Statement 159

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('TABLE','TB_NA_CTA_FINANCIALTRANS_5000','11','298','287','4')

1 row(s) inserted.

Statement 160

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('TABLE','TB_NCH_ALERT_UNITSCRB','1797','3142','1344','57')

1 row(s) inserted.

Statement 161

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('TABLE','TB_NODE','72','96','23','75')

1 row(s) inserted.

Statement 162

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('TABLE','TB_OLAM_MAINTENANCE_HISTORY','45','981','936','5')

1 row(s) inserted.

Statement 163

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('TABLE','TB_RTM_ALERT_INBOUND','18','8939','8921','0')

1 row(s) inserted.

Statement 164

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('TABLE','TB_RTM_LOG','228','16795','16567','1')

1 row(s) inserted.

Statement 165

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('TABLE','TB_SMS_ACK','55','1153','1098','5')

1 row(s) inserted.

Statement 166

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('TABLE','TB_SMS_AUDIT','277','1793','1516','15')

1 row(s) inserted.

Statement 167

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT_FRAGMENTATION) values ('TABLE','TB_SUPERVISOR','605','1230','625','49')

1 row(s) inserted.

Statement 168

Insert into TB_FRAGMENT_REPORT (TYPE,SEGMENT_NAME,RECLAIMABLE_SPACE_MB,ALLOCATED_SPACE_MB,USED_SPACE_MB,PCT

ORA-00917: missing comma

More Details: https://docs.oracle.com/error-help/db/ora-00917

Statement 169

select * from TB_FRAGMENT_REPORT


TYPE SEGMENT_NAME RECLAIMABLE_SPACE_MB ALLOCATED_SPACE_MB USED_SPACE_MB PCT_FRAGMENTATION
INDEX XIE1TB_TRANSACTION 19858 85193 65334 23
INDEX XIE1_TB_AUDIT 6852 66081 59228 10
INDEX XIE_TB_TSYS_REC_50 28 80 52 35
TABLE TB_LINE_ITEM 429 245988 245559 0
TABLE TB_LOGIN_MASTER 249 795 546 31
TABLE TB_MCCG_CARD 248 3598 3350 7
TABLE TB_NA_CTA_FINANCIALTRANS_5000 11 298 287 4
TABLE TB_NCH_ALERT_UNITSCRB 1797 3142 1344 57
TABLE TB_NODE 72 96 23 75
TABLE TB_OLAM_MAINTENANCE_HISTORY 45 981 936 5
TABLE TB_RTM_ALERT_INBOUND 18 8939 8921 0
TABLE TB_RTM_LOG 228 16795 16567 1
TABLE TB_SMS_ACK 55 1153 1098 5
TABLE TB_SMS_AUDIT 277 1793 1516 15
TABLE TB_SUPERVISOR 605 1230 625 49
INDEX IDX30PK 12 33 21 35
INDEX IDX_AP_BILL_ACC 265 2021 1756 13
INDEX IDX_AP_CARD_NO 365 2063 1698 18
INDEX IDX_AP_CS_CD_NO 316 1092 776 29
INDEX IDX_AP_PRIMARY_ACC 276 2022 1746 14
INDEX IDX_AP_PRINT_FLG 37 303 266 12
INDEX IDX_AP_TXN_POST_DT 164 1344 1180 12
INDEX IDX_AUD_INT_REC 10436 49203 38767 21
INDEX IDX_CUSTOM_TRANS_AER_SEQ_IMPL 18757 111559 92802 17
INDEX IDX_EM_CS_UPLD_ID 433 1665 1232 26
INDEX IDX_GROUP_NUMBER 12 52 40 23
INDEX IDX_LAST_PWDS_LOGIN_MASTER 86 378 292 23
INDEX IDX_MC_CARD_ID 87 691 604 13
INDEX IDX_MODIFIED_ON 156 2080 1924 7
INDEX IDX_RTM_TB_CARD_REQ_GRP_STAT_1 13 114 101 11
INDEX IDX_RWRDS_UIFD 877 1095 218 80
INDEX IDX_RWRD_CARDID 14 51 36 28
INDEX IDX_SOW_AUDIT_PK 706 3665 2959 19
INDEX IDX_TB_AUDIT_SECURITY_MAIN 9979 43879 33900 23
INDEX IDX_TB_CL_DOC_DETAILS_10 36 101 65 35
INDEX IDX_TB_CL_DOC_DETAILS_11 35 133 98 26
INDEX IDX_TB_CL_DOC_DETAILS_2 36 121 85 30
INDEX IDX_TB_CL_DOC_DETAILS_3 26 78 52 33
INDEX IDX_TB_CL_DOC_DETAILS_4 30 120 91 25
INDEX IDX_TB_CL_DOC_DETAILS_5 37 139 101 27
INDEX IDX_TB_CL_DOC_DETAILS_6 17 112 96 15
INDEX IDX_TB_CL_DOC_DETAILS_7 12 44 32 27
INDEX IDX_TB_CL_DOC_DETAILS_8 14 49 35 28
INDEX IDX_TB_CL_DOC_DETAILS_9 28 81 53 34
INDEX IDX_TB_CL_STATISTICS_EOD 12 181 169 7
INDEX IDX_TB_CL_TBR_MANIFEST_1 13 102 89 13
INDEX IDX_TB_CL_TBR_MANIFEST_2 62 310 248 20
INDEX IDX_TB_EMAIL_MULTILANG 16 46 30 35
INDEX IDX_TB_EMAIL_OUTBOUND_1 20 97 77 21
INDEX IDX_TB_GCMS_DET_RPT_CCN 41 119 78 34
INDEX IDX_TB_GCMS_DET_RPT_CNO 12 51 39 23
INDEX IDX_TB_GCMS_DET_RPT_GUI 13 63 50 20
INDEX IDX_TB_GCMS_DET_RPT_ISC 20 50 30 40
INDEX IDX_TB_GCMS_DET_RPT_ISU 14 41 27 35
INDEX IDX_TB_GCMS_DET_RPT_REG 32 86 54 37
INDEX IDX_TB_GCMS_DET_RPT_UST 11 56 45 19
INDEX IDX_TB_OLAM_MAIL_EXCE_KEY_CAT 12 47 35 25
INDEX IDX_TB_OLAM_MNT_HIST_1 74 491 417 15
INDEX IDX_TB_OLAM_MNT_HIST_2 42 183 141 23
INDEX IDX_TB_RTM_ALERT_INBOUND_1 30 198 168 15
INDEX IDX_TB_STATUS_HIST_FK_CARD_REQ 12 204 192 6
INDEX IDX_TB_TRANSACTION 13319 79671 66352 17
INDEX IDX_TB_UNIT_1 11 137 126 8
INDEX IDX_TRANS_OTHR_CORP_POST_DT 17866 80845 62980 22
INDEX IDX_TRANS_OTHR_MEMO_POST_DT 12930 57539 44609 22
INDEX IDX_TRANS_POST_DT 10500 42303 31803 25
INDEX IDX_USER_COMPANY_1 129 1218 1089 11
INDEX IX1_TB_CUST_TRANSACTION 9791 28616 18826 34
INDEX IX1_TB_TRANSACTION 13177 88694 75517 15
INDEX IX2_TB_CUSTOM_STATEMENT 2579 12604 10025 20
INDEX IX2_TB_CUST_TRANSACTION 14544 42413 27869 34
INDEX IX3_TB_CUSTOM_STATEMENT 1617 7764 6147 21
INDEX IX3_TB_TRANSACTION 6842 32398 25556 21
INDEX IX4_TB_CUSTOM_STATEMENT 2226 9063 6837 25
INDEX IX5_TB_CUSTOM_STATEMENT 1945 9058 7114 21
INDEX IX6_TB_CUSTOM_STATEMENT 1132 3608 2475 31
INDEX IX_ADDR_ZIPCODE 60 218 158 27
INDEX IX_AP_TXN_BILL_CURRENCY 82 990 908 8
INDEX IX_AP_TXN_SRC_CURRENCY 82 987 905 8
INDEX IX_BOUNCEDRPT_CORRELATION_ID 57 57 0 100
INDEX IX_CARDST_CARD_ID 32 6137 6105 1
INDEX IX_CLD_FK_LOGIN_MASTER 21 152 132 14
INDEX IX_CP_FK_ACCOUNT_NUMBER 22 202 180 11
INDEX IX_CRDPAY_REF_NUM 62 187 124 33
INDEX IX_FK_TB_AUDIT_MST 6247 28306 22059 22
INDEX IX_LD_FK_LOGIN_MASTER 17 246 229 7
INDEX IX_MCL_GEN_TIC_TXN 403 1349 946 30
INDEX IX_TB_AP_CARD_BALANCE_TOT 3049 19106 16057 16
INDEX IX_TB_AP_CARD_EPP_DET 1383 7845 6462 18
INDEX IX_TB_CM_STMT_ACCESSED 19 105 86 18
INDEX IX_TB_CUST_TRANSACTION 24851 113808 88957 22
INDEX IX_TB_EM_CARD_BALANCE_TOT 20361 74514 54153 27
INDEX IX_TB_EM_CARD_EPP_DET 10379 38314 27935 27
INDEX IX_TB_LINE_ITEM_TRANSACTIO 6787 54129 47342 13
INDEX IX_TB_TRANS_OTHER_ACCT_NBR 9017 41057 32040 22
INDEX IX_TCP_CARD_ID 28 137 108 21
INDEX IX_TC_ACCTYPEID 11 182 171 6
INDEX IX_TRAN_CARD_ID 5648 27833 22186 20
INDEX IX_TXN_DIVERTED_CARD_NBR 8806 41371 32565 21
INDEX IX_UA_FK_ALERT_MASTER 143 886 743 16
INDEX IX_UA_FK_LOGIN_MASTER 234 1287 1053 18
INDEX IX_UC_CARD_NO 25 251 226 10
INDEX IX_UC_FK_LOGIN_MASTER 120 984 864 12
INDEX IX_UC_FK_USER_COMPANY 119 851 732 14
INDEX IX_UD_EMAIL_ID 60 284 224 21
INDEX IX_UE_FK_ENTITLEMENT_MASTER 4601 48703 44103 9
INDEX IX_UE_FK_LOGIN_MASTER 10626 45507 34882 23
INDEX IX_UH_FK_REK_HIERARCHY 81 490 409 16
INDEX IX_UH_FK_UNIT_ID 121 780 659 15
INDEX IX_UNIT_CMP_ROLE 177 1108 931 16
INDEX IX_UR_FK_LOGIN_MASTER 118 983 865 12
INDEX IX_UR_FK_ROLE1 108 733 625 15
INDEX IX_USER_ALERTS_STATUS 169 858 689 20
INDEX IX_USER_HIER_FK_ROLE 81 485 404 17
INDEX PK_EM_MCL_CARDACCEPTOR 828 3113 2285 27
INDEX PK_EM_MCL_FINANCIALTRANSACTION 802 3098 2297 26
INDEX PK_TB_ALERT_INVOICE_GENR 19 52 33 37
INDEX PK_TB_ALERT_PAYMENT_GENR 19 124 106 15
INDEX PK_TB_AP_CARD_BALANCE_TOT 3832 24097 20265 16
INDEX PK_TB_AP_CARD_STATEMENT 314 1108 794 28
INDEX PK_TB_AP_CARD_TRANSACTION 835 4729 3894 18
INDEX PK_TB_AUDIT_SECURITY 33 7153 7120 0
INDEX PK_TB_BOUNCE_EMAIL_TRACK 16 16 0 100
INDEX PK_TB_EM_CARD_BALANCE_TOT 34585 103784 69199 33
INDEX PK_TB_EM_CARD_EPP_DET 18241 54687 36446 33
INDEX PK_TB_EM_CARD_TRANSACTION 4441 17592 13151 25
INDEX PK_TB_USER_ENTITLEMENTS 246 40180 39935 1
INDEX SYS_C006799 34 220 186 15
INDEX SYS_C006801 44 252 208 17
INDEX SYS_C006803 125 544 419 23
INDEX SYS_C006807 41 247 206 16
INDEX SYS_C006809 11 61 50 17
INDEX SYS_C006810 2444 11300 8856 22
INDEX SYS_C006819 159 687 528 23
INDEX SYS_C006825 7540 45749 38209 16
INDEX SYS_C006826 355 1928 1573 18
INDEX SYS_C006828 2039 3565 1526 57
INDEX SYS_C006888 4596 23565 18969 20
INDEX SYS_C006889 1162 6376 5214 18
INDEX SYS_C007030 14 2566 2552 1
INDEX TB_ACCOUNT_ALT_UIFID 10 13 3 81
INDEX TB_ACCOUNT_AUTH_UIFID 2236 2757 521 81
INDEX TB_ACCOUNT_UIFID 113 320 207 35
INDEX TB_CARD_COMPANY_UIFID 14 17 4 79
INDEX TB_CARD_EXTENSION_UIFID 3591 9664 6073 37
INDEX TB_CARD_FLEET_EXTENSION_UI 342 452 110 76
INDEX TB_CARD_STATEMENT_UIFID 115 6072 5957 2
INDEX TB_CAR_RENTAL_LINE_ITEM_UI 97 507 410 19
INDEX TB_CCMS_MAINTAIN_RESPONSE_PK 14 775 761 2
INDEX TB_COMPANY_UIFID 14 18 4 79
INDEX TB_DELIVERY_FAILURE_RPT 16 16 0 99
INDEX TB_FLEET_LINE_ITEM_UIFID 127 653 526 19
INDEX TB_FLEET_TABLE_UIFID 13 15 2 87
INDEX TB_LINE_ITEM_UIFID 8538 54516 45978 16
INDEX TB_LODGING_LINE_ITEM_UIFID 465 1988 1523 23
INDEX TB_LOGIN_MASTER_IX 58 175 117 33
INDEX TB_MCCG_CARD_UIFID 3781 5355 1574 71
INDEX TB_MCC_GROUP_UIFID 45 53 8 85
INDEX TB_MERCHANT_UIFID 1125 4510 3385 25
INDEX TB_TRANSACTION_UIFID 6538 26091 19553 25
INDEX TB_TRAVEL_LINE_ITEM_UIFID 1741 6985 5244 25
INDEX XAK1TB_LINE_ITEM 740 91651 90911 1
INDEX XAK1TB_MERCHANT 3389 18125 14736 19
INDEX XCARD_UPDATED 85 427 341 20
INDEX XCARD_UPDATED_IMPORT_FILE_ID 201 451 250 45
INDEX XIE1TB_FLEET_TABLE 19 23 4 84

166 rows selected.

Fragmentation_Report

Additional Information

TYPE	SEGMENT_NAME	RECLAIMABLE_SPACE_MB	ALLOCATED_SPACE_MB	USED_SPACE_MB	PCT_FRAGMENTATION
INDEX	XIE1TB_TRANSACTION	19858	85193	65334	23
INDEX	XIE1_TB_AUDIT	6852	66081	59228	10
INDEX	XIE_TB_TSYS_REC_50	28	80	52	35
TABLE	TB_LINE_ITEM	429	245988	245559	0
TABLE	TB_LOGIN_MASTER	249	795	546	31
TABLE	TB_MCCG_CARD	248	3598	3350	7
TABLE	TB_NA_CTA_FINANCIALTRANS_5000	11	298	287	4
TABLE	TB_NCH_ALERT_UNITSCRB	1797	3142	1344	57
TABLE	TB_NODE	72	96	23	75
TABLE	TB_OLAM_MAINTENANCE_HISTORY	45	981	936	5
TABLE	TB_RTM_ALERT_INBOUND	18	8939	8921	0
TABLE	TB_RTM_LOG	228	16795	16567	1
TABLE	TB_SMS_ACK	55	1153	1098	5
TABLE	TB_SMS_AUDIT	277	1793	1516	15
TABLE	TB_SUPERVISOR	605	1230	625	49
INDEX	IDX30PK	12	33	21	35
INDEX	IDX_AP_BILL_ACC	265	2021	1756	13
INDEX	IDX_AP_CARD_NO	365	2063	1698	18
INDEX	IDX_AP_CS_CD_NO	316	1092	776	29
INDEX	IDX_AP_PRIMARY_ACC	276	2022	1746	14
INDEX	IDX_AP_PRINT_FLG	37	303	266	12
INDEX	IDX_AP_TXN_POST_DT	164	1344	1180	12
INDEX	IDX_AUD_INT_REC	10436	49203	38767	21
INDEX	IDX_CUSTOM_TRANS_AER_SEQ_IMPL	18757	111559	92802	17
INDEX	IDX_EM_CS_UPLD_ID	433	1665	1232	26
INDEX	IDX_GROUP_NUMBER	12	52	40	23
INDEX	IDX_LAST_PWDS_LOGIN_MASTER	86	378	292	23
INDEX	IDX_MC_CARD_ID	87	691	604	13
INDEX	IDX_MODIFIED_ON	156	2080	1924	7
INDEX	IDX_RTM_TB_CARD_REQ_GRP_STAT_1	13	114	101	11
INDEX	IDX_RWRDS_UIFD	877	1095	218	80
INDEX	IDX_RWRD_CARDID	14	51	36	28
INDEX	IDX_SOW_AUDIT_PK	706	3665	2959	19
INDEX	IDX_TB_AUDIT_SECURITY_MAIN	9979	43879	33900	23
INDEX	IDX_TB_CL_DOC_DETAILS_10	36	101	65	35
INDEX	IDX_TB_CL_DOC_DETAILS_11	35	133	98	26
INDEX	IDX_TB_CL_DOC_DETAILS_2	36	121	85	30
INDEX	IDX_TB_CL_DOC_DETAILS_3	26	78	52	33
INDEX	IDX_TB_CL_DOC_DETAILS_4	30	120	91	25
INDEX	IDX_TB_CL_DOC_DETAILS_5	37	139	101	27
INDEX	IDX_TB_CL_DOC_DETAILS_6	17	112	96	15
INDEX	IDX_TB_CL_DOC_DETAILS_7	12	44	32	27
INDEX	IDX_TB_CL_DOC_DETAILS_8	14	49	35	28
INDEX	IDX_TB_CL_DOC_DETAILS_9	28	81	53	34
INDEX	IDX_TB_CL_STATISTICS_EOD	12	181	169	7
INDEX	IDX_TB_CL_TBR_MANIFEST_1	13	102	89	13
INDEX	IDX_TB_CL_TBR_MANIFEST_2	62	310	248	20
INDEX	IDX_TB_EMAIL_MULTILANG	16	46	30	35
INDEX	IDX_TB_EMAIL_OUTBOUND_1	20	97	77	21
INDEX	IDX_TB_GCMS_DET_RPT_CCN	41	119	78	34
INDEX	IDX_TB_GCMS_DET_RPT_CNO	12	51	39	23
INDEX	IDX_TB_GCMS_DET_RPT_GUI	13	63	50	20
INDEX	IDX_TB_GCMS_DET_RPT_ISC	20	50	30	40
INDEX	IDX_TB_GCMS_DET_RPT_ISU	14	41	27	35
INDEX	IDX_TB_GCMS_DET_RPT_REG	32	86	54	37
INDEX	IDX_TB_GCMS_DET_RPT_UST	11	56	45	19
INDEX	IDX_TB_OLAM_MAIL_EXCE_KEY_CAT	12	47	35	25
INDEX	IDX_TB_OLAM_MNT_HIST_1	74	491	417	15
INDEX	IDX_TB_OLAM_MNT_HIST_2	42	183	141	23
INDEX	IDX_TB_RTM_ALERT_INBOUND_1	30	198	168	15
INDEX	IDX_TB_STATUS_HIST_FK_CARD_REQ	12	204	192	6
INDEX	IDX_TB_TRANSACTION	13319	79671	66352	17
INDEX	IDX_TB_UNIT_1	11	137	126	8
INDEX	IDX_TRANS_OTHR_CORP_POST_DT	17866	80845	62980	22
INDEX	IDX_TRANS_OTHR_MEMO_POST_DT	12930	57539	44609	22
INDEX	IDX_TRANS_POST_DT	10500	42303	31803	25
INDEX	IDX_USER_COMPANY_1	129	1218	1089	11
INDEX	IX1_TB_CUST_TRANSACTION	9791	28616	18826	34
INDEX	IX1_TB_TRANSACTION	13177	88694	75517	15
INDEX	IX2_TB_CUSTOM_STATEMENT	2579	12604	10025	20
INDEX	IX2_TB_CUST_TRANSACTION	14544	42413	27869	34
INDEX	IX3_TB_CUSTOM_STATEMENT	1617	7764	6147	21
INDEX	IX3_TB_TRANSACTION	6842	32398	25556	21
INDEX	IX4_TB_CUSTOM_STATEMENT	2226	9063	6837	25
INDEX	IX5_TB_CUSTOM_STATEMENT	1945	9058	7114	21
INDEX	IX6_TB_CUSTOM_STATEMENT	1132	3608	2475	31
INDEX	IX_ADDR_ZIPCODE	60	218	158	27
INDEX	IX_AP_TXN_BILL_CURRENCY	82	990	908	8
INDEX	IX_AP_TXN_SRC_CURRENCY	82	987	905	8
INDEX	IX_BOUNCEDRPT_CORRELATION_ID	57	57	0	100
INDEX	IX_CARDST_CARD_ID	32	6137	6105	1
INDEX	IX_CLD_FK_LOGIN_MASTER	21	152	132	14
INDEX	IX_CP_FK_ACCOUNT_NUMBER	22	202	180	11
INDEX	IX_CRDPAY_REF_NUM	62	187	124	33
INDEX	IX_FK_TB_AUDIT_MST	6247	28306	22059	22
INDEX	IX_LD_FK_LOGIN_MASTER	17	246	229	7
INDEX	IX_MCL_GEN_TIC_TXN	403	1349	946	30
INDEX	IX_TB_AP_CARD_BALANCE_TOT	3049	19106	16057	16
INDEX	IX_TB_AP_CARD_EPP_DET	1383	7845	6462	18
INDEX	IX_TB_CM_STMT_ACCESSED	19	105	86	18
INDEX	IX_TB_CUST_TRANSACTION	24851	113808	88957	22
INDEX	IX_TB_EM_CARD_BALANCE_TOT	20361	74514	54153	27
INDEX	IX_TB_EM_CARD_EPP_DET	10379	38314	27935	27
INDEX	IX_TB_LINE_ITEM_TRANSACTIO	6787	54129	47342	13
INDEX	IX_TB_TRANS_OTHER_ACCT_NBR	9017	41057	32040	22
INDEX	IX_TCP_CARD_ID	28	137	108	21
INDEX	IX_TC_ACCTYPEID	11	182	171	6
INDEX	IX_TRAN_CARD_ID	5648	27833	22186	20
INDEX	IX_TXN_DIVERTED_CARD_NBR	8806	41371	32565	21
INDEX	IX_UA_FK_ALERT_MASTER	143	886	743	16
INDEX	IX_UA_FK_LOGIN_MASTER	234	1287	1053	18
INDEX	IX_UC_CARD_NO	25	251	226	10
INDEX	IX_UC_FK_LOGIN_MASTER	120	984	864	12
INDEX	IX_UC_FK_USER_COMPANY	119	851	732	14
INDEX	IX_UD_EMAIL_ID	60	284	224	21
INDEX	IX_UE_FK_ENTITLEMENT_MASTER	4601	48703	44103	9
INDEX	IX_UE_FK_LOGIN_MASTER	10626	45507	34882	23
INDEX	IX_UH_FK_REK_HIERARCHY	81	490	409	16
INDEX	IX_UH_FK_UNIT_ID	121	780	659	15
INDEX	IX_UNIT_CMP_ROLE	177	1108	931	16
INDEX	IX_UR_FK_LOGIN_MASTER	118	983	865	12
INDEX	IX_UR_FK_ROLE1	108	733	625	15
INDEX	IX_USER_ALERTS_STATUS	169	858	689	20
INDEX	IX_USER_HIER_FK_ROLE	81	485	404	17
INDEX	PK_EM_MCL_CARDACCEPTOR	828	3113	2285	27
INDEX	PK_EM_MCL_FINANCIALTRANSACTION	802	3098	2297	26
INDEX	PK_TB_ALERT_INVOICE_GENR	19	52	33	37
INDEX	PK_TB_ALERT_PAYMENT_GENR	19	124	106	15
INDEX	PK_TB_AP_CARD_BALANCE_TOT	3832	24097	20265	16
INDEX	PK_TB_AP_CARD_STATEMENT	314	1108	794	28
INDEX	PK_TB_AP_CARD_TRANSACTION	835	4729	3894	18
INDEX	PK_TB_AUDIT_SECURITY	33	7153	7120	0
INDEX	PK_TB_BOUNCE_EMAIL_TRACK	16	16	0	100
INDEX	PK_TB_EM_CARD_BALANCE_TOT	34585	103784	69199	33
INDEX	PK_TB_EM_CARD_EPP_DET	18241	54687	36446	33
INDEX	PK_TB_EM_CARD_TRANSACTION	4441	17592	13151	25
INDEX	PK_TB_USER_ENTITLEMENTS	246	40180	39935	1
INDEX	SYS_C006799	34	220	186	15
INDEX	SYS_C006801	44	252	208	17
INDEX	SYS_C006803	125	544	419	23
INDEX	SYS_C006807	41	247	206	16
INDEX	SYS_C006809	11	61	50	17
INDEX	SYS_C006810	2444	11300	8856	22
INDEX	SYS_C006819	159	687	528	23
INDEX	SYS_C006825	7540	45749	38209	16
INDEX	SYS_C006826	355	1928	1573	18
INDEX	SYS_C006828	2039	3565	1526	57
INDEX	SYS_C006888	4596	23565	18969	20
INDEX	SYS_C006889	1162	6376	5214	18
INDEX	SYS_C007030	14	2566	2552	1
INDEX	TB_ACCOUNT_ALT_UIFID	10	13	3	81
INDEX	TB_ACCOUNT_AUTH_UIFID	2236	2757	521	81
INDEX	TB_ACCOUNT_UIFID	113	320	207	35
INDEX	TB_CARD_COMPANY_UIFID	14	17	4	79
INDEX	TB_CARD_EXTENSION_UIFID	3591	9664	6073	37
INDEX	TB_CARD_FLEET_EXTENSION_UI	342	452	110	76
INDEX	TB_CARD_STATEMENT_UIFID	115	6072	5957	2
INDEX	TB_CAR_RENTAL_LINE_ITEM_UI	97	507	410	19
INDEX	TB_CCMS_MAINTAIN_RESPONSE_PK	14	775	761	2
INDEX	TB_COMPANY_UIFID	14	18	4	79
INDEX	TB_DELIVERY_FAILURE_RPT	16	16	0	99
INDEX	TB_FLEET_LINE_ITEM_UIFID	127	653	526	19
INDEX	TB_FLEET_TABLE_UIFID	13	15	2	87
INDEX	TB_LINE_ITEM_UIFID	8538	54516	45978	16
INDEX	TB_LODGING_LINE_ITEM_UIFID	465	1988	1523	23
INDEX	TB_LOGIN_MASTER_IX	58	175	117	33
INDEX	TB_MCCG_CARD_UIFID	3781	5355	1574	71
INDEX	TB_MCC_GROUP_UIFID	45	53	8	85
INDEX	TB_MERCHANT_UIFID	1125	4510	3385	25
INDEX	TB_TRANSACTION_UIFID	6538	26091	19553	25
INDEX	TB_TRAVEL_LINE_ITEM_UIFID	1741	6985	5244	25
INDEX	XAK1TB_LINE_ITEM	740	91651	90911	1
INDEX	XAK1TB_MERCHANT	3389	18125	14736	19
INDEX	XCARD_UPDATED	85	427	341	20
INDEX	XCARD_UPDATED_IMPORT_FILE_ID	201	451	250	45
INDEX	XIE1TB_FLEET_TABLE	19	23	4	84