Home » SQL & PL/SQL » SQL & PL/SQL » Concurrent Insert statements Using Dbms_job.Submit (Oracle 9i)
Concurrent Insert statements Using Dbms_job.Submit [message #337728] Thu, 31 July 2008 21:00 Go to next message
victory_nag
Messages: 36
Registered: June 2008
Location: CA
Member
Hello,

I have a huge amount of data to be loaded (12 millions).
The target table holds 500 columns. I have to load data from around 20 source tables.
The approach I was suggested by my senior DBA's was

-Divide the data into 6 equal chunks and load(Bulk Insert) them concurrently using dbms_job.submit package and monitor the job status with dbms_alert packages.

I never worked with dbms_job.submit and dbms_alert package. So please, anyone of you explain how to load data using these packages.

I want to call 6 Bulk Inserts all at once and load the data.

Thanks.
Re: Concurrent Insert statements Using Dbms_job.Submit [message #337730 is a reply to message #337728] Thu, 31 July 2008 21:07 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
EVERY time you have posted here you've been asked to :

Please read & follow Posting Guideline as stated in URL below
http://www.orafaq.com/forum/t/88153/0/

>So please, anyone of you explain how to load data using these packages.
Go admit to your DBA that you are clueless & are either incapable or unwilling to RTFM found at
http://tahiti.oracle.com

Why should we waste our time & effort reposting here, what is already documented in the Oracle manuals?

You're On Your Own (YOYO)!


[Updated on: Thu, 31 July 2008 21:07] by Moderator

Report message to a moderator

Re: Concurrent Insert statements Using Dbms_job.Submit [message #337756 is a reply to message #337728] Fri, 01 August 2008 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
12 millions is not huge.

You can use use parallel and direct load.

Regards
Michel
Re: Concurrent Insert statements Using Dbms_job.Submit [message #338127 is a reply to message #337756] Sun, 03 August 2008 21:52 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
From memory (you'd better confirm this), PARALLEL DIRECT path load invalidates indexes, whereas (serial) DIRECT path load can load into indexes as well.

If the table is small (or empty) then PARALLEL DIRECT will be much faster. As the number of pre-existing rows increases, PARALLEL DIRECT will become less efficient to the point that PARALLEL=FALSE (ie. serial) is better.

Ross Leishman
Previous Topic: Invalid Number exception with the cursor
Next Topic: month values from date/varchar2 column (merged)
Goto Forum:
  


Current Time: Sun Dec 04 22:55:45 CST 2016

Total time taken to generate the page: 0.12914 seconds