| Loading objects in parallel? [message #314262] |
Wed, 16 April 2008 04:04  |
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  |
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 |
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 #314578 is a reply to message #314562] |
Thu, 17 April 2008 03:53 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
