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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic: help in using DBMS_JOB
Next Topic: DBMS_PROFILER at instance Level
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 23:54:47 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.