Home » RDBMS Server » Performance Tuning » Performace Tuning Of Insert Statement
Performace Tuning Of Insert Statement [message #65203] Thu, 10 June 2004 02:56 Go to next message
Messages: 13
Registered: October 2002
Junior Member
We have a Data Migration script whihc inserts thousands of row using

For i in 1 .. 10000000


Insert Into (column-name)

Values (<values);

End Loop;

So wanted to know how to tune it. I am aware of /*+ append*/

and nologging clause used for bulk Inserts . How can I tune this kind of inserts with Values clause as above.

Any help wud be greately appreciated.
Re: Performace Tuning Of Insert Statement [message #65204 is a reply to message #65203] Thu, 10 June 2004 08:01 Go to previous message
Messages: 582
Registered: December 2000
Senior Member
You cannot use /*+append*/ with VALUES.
You can only use /*+append*/ when you INSERT /*+append*/ INTO tbl

It would be helpful if you sent your code example.
Previous Topic: help in using DBMS_JOB
Next Topic: DBMS_PROFILER at instance Level
Goto Forum:

Current Time: Mon Mar 04 18:48:42 CST 2024