-
SQL Loader - process runs slow
Hi ALL,
I have 40000 records to load from a file. I have around 200 columns.
Of which atleast 20 columns have DATE conversion logic on them.
At present this job takes 3 minutes if I dont give this parameter ROWS=10000 BINDSIZE=20000000 READSIZE=20000000.
Now it take 52 seconds
I am just pasting a part of the log file.
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 10000 rows, maximum of 20000000 bytes
Continuation: none specified
Path used: Conventional
Table IPDR_3G_REL2_TMP, loaded from every logical record.
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect
Table IPDR_3G_REL2_TMP:
39962 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Space allocated for bind array: 19973898 bytes(742 rows)
Read buffer bytes:20000000
Total logical records skipped: 0
Total logical records read: 39962
Total logical records rejected: 0
Total logical records discarded: 0
Run began on Mon Nov 07 11:57:33 2005
Run ended on Mon Nov 07 11:58:25 2005
Elapsed time was: 00:00:51.90
CPU time was: 00:00:23.32
Thanks in advance.
Cheers
Cheers!
OraKid.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|