| sqlldr slow loading tables with lobs [message #73610] |
Tue, 01 June 2004 10:57 |
Rick Louden
Messages: 1
Registered: June 2004
|
Junior Member |
|
|
I use sqlldr to load several tables including 2 with a single clob column each. Non-clob tables (<=6M rows) load in <2 minutes on 2-cpu development server and clob tables (<= 650K rows) load in about 1 hour each. Non-clob tables load slightly slower on 4-cpu production server with faster processors; the 2 clob tables take up to 6 hours each. Parameter values are identical except production has larger SGA values. The data, lob, and rollback tablespaces and source data file are all on different disks. There are no indexes or keys on any tables. Tables and lobs are nologging / nocache. Tablespaces are all nologging. Unix command prstat shows activity for lgwr and the sqlldr job, both < 1% of the cpu. All unix and oracle scripts and the sqlldr ctl files are identical on development and production servers. I think log_file_sync waits may be the problem. Both databases are 8.1.7.
I appreciate any suggestions about the log_file_sync waits or any other suggestions also.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
