Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Script to build indexes in parallel
That's the way it *should* be done.
1 queue, multiple servers.
On Dec 19, 2007 11:14 AM, Tony Aponte <Tony_Aponte_at_jabil.com> wrote:
>
>
>
>
> Try this to see if it fits your needs. I've used it to do pretty much the
> same task you describe. The script accepts a degree of parallelism and an
> input file containing commands to execute.
>
>
>
> http://sysadmintalk.com/showthread.php?threadid=762
>
>
>
>
>
> Tony Aponte
>
>
>
> ________________________________
>
>
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Charles Schultz
> Sent: Tuesday, December 18, 2007 4:44 PM
> To: Oracle-L
> Subject: Script to build indexes in parallel
>
>
>
>
> Anyone have a script to read a DDL file and build indexes using parallel
> worker processes? Something in perl or shell would be preferable. I am
> trying to work around data pump's slow "feature" of building indexes with
> one query coordinator by extracting the metadata ddl and running them with
> real parallelization. I was just getting started with a perl script using
> fork but wanted to check here so as not to reinvent the wheel.
>
> --
> Charles Schultz
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 19 2007 - 17:30:43 CST
![]() |
![]() |