OraFAQ Forum: Performance Tuning » Performace Tuning Of Insert Statement

Home » RDBMS Server » Performance Tuning » Performace Tuning Of Insert Statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Performace Tuning Of Insert Statement [message #65203]

Thu, 10 June 2004 02:56

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 23 16:36:12 CDT 2025