Hi,

what are the parameters that I put on control file of sqqldr to quick the loading data ?

I have IOT (index organization Table) partitioned by day, please help me for tuning sqlldr Vs index primary key to avoid back log ( to quick insert)

Average data loaded per day is 150 Millions

Desc my_table
CREATE TABLE DBM_MSC_CDR
(
  SUBNO             VARCHAR2(20 BYTE),
  B_SUBNO           VARCHAR2(20 BYTE),
  CALL_DURATION     NUMBER(5),
  CALL_TYPE         VARCHAR2(3 BYTE),
  TRANSDATE         DATE,
  FILE_ID           NUMBER(9),
  UPDDATE           DATE                        DEFAULT trunc(sysdate),
  CONSTRAINT DBM_MSC_CDR_PK PRIMARY KEY (SUBNO, B_SUBNO, TRANSDATE, CALL_TYPE, CALL_DURATION)
)
ORGANIZATION INDEX
  PARTITION BY RANGE (TRANSDATE)

Best regards
 


Oracle LazyDBA home page