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
Kchitij
Messages: 13
Registered: October 2002
Junior Member
We have a Data Migration script whihc inserts thousands of row using

For i in 1 .. 10000000

Loop

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
sverch
Messages: 582
Registered: December 2000
Senior Member
You cannot use /*+append*/ with VALUES.
You can only use /*+append*/ when you INSERT /*+append*/ INTO tbl
SELECT....FROM...

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: Thu Mar 28 04:40:34 CDT 2024