| Oracle runs slow due to large inserts [message #52857] |
Sat, 17 August 2002 12:43  |
Vivek nath
Messages: 9
Registered: August 2002
|
Junior Member |
|
|
|
I have been inserting thousands of new records into the oracle database from an external file.The performance of oracle has become really slow and every new insert is taking hell lot of a time .Please tell me what can be done to improve this
|
|
|
|
| Re: Oracle runs slow due to large inserts [message #52864 is a reply to message #52857] |
Sun, 18 August 2002 11:30  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Read the the methods explainted SQL*Loader Performance Improvments
Also you can split your external data file in multiple pieces and then run SQL*Loader in parallel:
For example, to invoke three SQL*Loader direct path load sessions on the same table, you would execute the following commands at the operating system prompt:
SQLLOAD USERID=SCOTT/TIGER CONTROL=LOAD1.CTL DIRECT=TRUE PARALLEL=TRUE
SQLLOAD USERID=SCOTT/TIGER CONTROL=LOAD2.CTL DIRECT=TRUE PARALLEL=TRUE
SQLLOAD USERID=SCOTT/TIGER CONTROL=LOAD3.CTL DIRECT=TRUE PARALLEL=TRUE
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
