Home » SQL & PL/SQL » SQL & PL/SQL » Serial And Parallel Direct-Path Insert (Oracle 9i, Windows XP)
Serial And Parallel Direct-Path Insert [message #436704] Sat, 26 December 2009 01:14 Go to next message
zahidbashir
Messages: 34
Registered: September 2009
Member
Hi,
Just wanted to know that is it possible to direct-path insert serially if the parallel DML mode is enabled. If yes how?
alter session enable parallel dml;


Or we would have to disable the parallel dml mode before doing so?

Furter I have been searching the web for code examples of Direct-path inserts but found nothing. Please provide me with the links on the subject other than that oracle Direct-path documentation.

Regards,
Re: Serial And Parallel Direct-Path Insert [message #436707 is a reply to message #436704] Sat, 26 December 2009 01:57 Go to previous message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't mention a parallelism clause then there is no parallelism; if want to be sure then add "PARALLEL 1" hint.

Regards
Michel
Previous Topic: INITCAP sql function and apostrophes
Next Topic: query to get year,month and days from dob
Goto Forum:
  


Current Time: Sun Sep 25 11:10:09 CDT 2016

Total time taken to generate the page: 0.11691 seconds