| sqlldr and timing [message #70870] |
Thu, 01 August 2002 09:58  |
RR
Messages: 19
Registered: October 2001
|
Junior Member |
|
|
Hi,
I am totally new to oracle. I am trying to measure the amount of time it takes to complete the inserts in a simple table.
Here's my lcontrol file for sqlldr:
LOAD DATA
INFILE *
INTO TABLE perf_test1
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
( datastring
)
BEGINDATA
11111AAAAAAAAAA
11111,AAAAAAAAAA
22222,"A,B,C,D,"
This works and data is inserted in the table. Now How can I measure the amount of time it takes to complete this insert?
Thanks a lot
|
|
|
|
| Re: sqlldr and timing [message #70888 is a reply to message #70870] |
Wed, 07 August 2002 23:25  |
Sam
Messages: 255
Registered: April 2000
|
Senior Member |
|
|
|
create a log file by having log=filename.log as a parameter when running sqlldr. The log captures the start time and end time for the run.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
