Home » RDBMS Server » Performance Tuning » Loading objects in parallel? (Oracle 10.2.0.3 on Sun OS 5.10)
Loading objects in parallel? [message #314262] Wed, 16 April 2008 04:04 Go to next message
Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway
Member
Hi all

Our application is heavily based on PL/SQL packages and we have an issue with releases taking too long because installing all our objects into a new environment takes a lot of time.

What we need to install is
* Packages
* Tables
* Triggers
* Sequences
* Access packages
* Datasets

Would we gain something from doing tables in one process, spawn another process and install/compile packages in this process? Any other combinations that would yield some speed? Could we have even more processes running installations/loads in parallel in this scenario?

We have about 5000 packages, 1500 tables and about the same number of sequences, 24000 synonyms, and 1900 views.

Any help appreciated. Thanks.
Re: Loading objects in parallel? [message #314390 is a reply to message #314262] Wed, 16 April 2008 09:44 Go to previous messageGo to next message
Anvar Huseynov
Messages: 2
Registered: April 2008
Location: London, UK
Junior Member
Split table creation script into several smaller ones, for example, 3 scripts that create 500 tables each, and run them simultaneously in different sessions. This might get the job done quicker.
You can also run sequence creation script at the same time. Packages, triggers and views have interdependencies, so it is better not to change their running order to avoid recompilation.
Re: Loading objects in parallel? [message #314547 is a reply to message #314390] Thu, 17 April 2008 02:23 Go to previous messageGo to next message
Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway
Member
Anvar Huseynov wrote on Wed, 16 April 2008 16:44
Split table creation script into several smaller ones, for example, 3 scripts that create 500 tables each, and run them simultaneously in different sessions. This might get the job done quicker.
You can also run sequence creation script at the same time. Packages, triggers and views have interdependencies, so it is better not to change their running order to avoid recompilation.

Thanks, Anvar. Have you tried this yourself and found significant overall speed increase?
Re: Loading objects in parallel? [message #314562 is a reply to message #314547] Thu, 17 April 2008 03:06 Go to previous messageGo to next message
Anvar Huseynov
Messages: 2
Registered: April 2008
Location: London, UK
Junior Member
I have tried it in different situations and sometimes it helped, sometimes it didn't. It depends on many factors. You should test it yourself.
Re: Loading objects in parallel? [message #314578 is a reply to message #314562] Thu, 17 April 2008 03:53 Go to previous message
Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway
Member
Anvar Huseynov wrote on Thu, 17 April 2008 10:06
I have tried it in different situations and sometimes it helped, sometimes it didn't. It depends on many factors. You should test it yourself.

Thanks again, Anvar.
Previous Topic: Performance discrepancies
Next Topic: tuning the view (merged)
Goto Forum:
  


Current Time: Fri Dec 09 04:08:15 CST 2016

Total time taken to generate the page: 0.15556 seconds