Re: Script to build indexes in parallel
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: Tony_Aponte@xxxxxxxxx
- Date: Wed, 19 Dec 2007 15:30:43 -0800
That's the way it *should* be done.
1 queue, multiple servers.
On Dec 19, 2007 11:14 AM, Tony Aponte <Tony_Aponte@xxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
