| sql loader direct path is taking more time [message #323704] |
Thu, 29 May 2008 05:14  |
mahik
Messages: 2
Registered: May 2008
|
Junior Member |
|
|
Hi,
I wants to load a csv file into oracle database, Here the Database software is of Release 10.2.0.1.0 and the operating system of Redhat Linux.
The CSV is having data of 120 million records, firstly i tried with the option of using insert /*+ APPEND */ into CAPTOR_TDR_MSC
where this table is an external table, to complete this task it has taken 40 mins.
Then i tried with the option :
sqlldr captor/captor control=captor_csv.ctl log=direct.log errors=500000 direct=true
it has taken 01:21:00.30 much of time. I assume that direct = true directly writes to data, and is better option than using insert /*+ APPEND */ into.... option.
Can you please explain me whats happened exactly for the slowness to load the data using direct=true option.
Any suggestions to improve this situation with direct=true.
Thanks in Advance
Mahik
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
