Oracle Utilities Tips for sqlldr control
file
The log file contains information about
the SQL*loader execution. It should be viewed after each
SQL*Loader job is complete. Especially interesting is the
summary information at the bottom of the log, including CPU
time and elapsed time. The data below is a sample of the
contents of the log file.
*****************************************************************************************
SQL*Loader: Release
9.2.0.1.0 - Production on Mon Mar 10 23:39:04 2003
Copyright (c) 1982, 2002,
Oracle Corporation. All rights reserved.
*****************************************************************************************
Control File:
sqlload.par
Data File:
sqlload.txt
Bad File:
sqlload.bad
Discard File: none
specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Continuation: none
specified
Path used: Direct
Table
TABLE_WITH_ONE_MILLION_ROWS, loaded from every logical
record.
Insert option in effect
for this table: INSERT
TRAILING NULLCOLS option
in effect
Table
TABLE_WITH_ONE_MILLION_ROWS, loaded from every logical
record.
Insert option in effect
for this table: INSERT
TRAILING NULLCOLS option
in effect
Column
Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ----
---------
COL1 FIRST * ,
CHARACTER
NULL if COL1 = BLANKS
COL2 NEXT * ,
CHARACTER
NULL if COL2 = BLANKS
COL3 NEXT * ,
CHARACTER
NULL if COL3 = BLANKS
COL4 NEXT * ,
CHARACTER
NULL if COL4 = BLANKS
COL5 NEXT * ,
CHARACTER
NULL if COL5 = BLANKS
COL6
NEXT * , DATE
MMDDYYYY
NULL if COL6 = BLANKS
Table
TABLE_WITH_ONE_MILLION_ROWS:
1000000 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.
Date cache:
Max Size: 1000
Entries : 1
Hits : 999999
Misses : 0
Bind array size not used
in direct path.
Column array rows :
5000
Stream buffer bytes:
512000
Read buffer bytes:
1048576
Total logical records
skipped: 0
Total logical records
read: 1000000
Total logical records
rejected: 0
Total logical records
discarded: 0
Total stream buffers
loaded by SQL*Loader main thread: 255
Total stream buffers
loaded by SQL*Loader load thread: 128
Run began on Mon Mar 10
23:39:04 2003
Run ended on Mon Mar 10
23:39:51 2003
Elapsed time was:
00:00:47.55
CPU time was:
00:00:12.85
To learn more about these techniques,
see the book "Advanced
Oracle Utilities: The Definitive Reference".
You can buy it directly from the
publisher and get instant access to the code
depot of utilities scripts. |