What kind of server are you on? Unix?

-----Original Message-----
From: Zoheir Belmahdi [mailto:oracledba-ezmlmshield-x36494873.[Email address protected]
Sent: Thursday, July 19, 2007 8:42 AM
To: LazyDBA Discussion
Subject: tune sqlldr

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
 



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page