Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 16624 invoked from network); 19 Dec 2007 22:24:35 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 19 Dec 2007 22:24:35 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 091F67DC3CF; Wed, 19 Dec 2007 23:24:36 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13107-08; Wed, 19 Dec 2007 23:24:35 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 74B527DC258; Wed, 19 Dec 2007 23:24:35 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 19 Dec 2007 22:37:09 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C28DC7DD2A3 for ; Wed, 19 Dec 2007 22:37:09 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01696-03 for ; Wed, 19 Dec 2007 22:37:09 -0500 (EST) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.243]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6B8017DD2E2 for ; Wed, 19 Dec 2007 22:37:08 -0500 (EST) Received: by an-out-0708.google.com with SMTP id b36so1628953ana.101 for ; Wed, 19 Dec 2007 19:37:08 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=K1KPCD0JYZjy1t+PVYGeUynUBafOMfgwGTPIro8GLqU=; b=VAPRocthxceFisGKpFhnxHeysoPDKyA5NvXb7heHt4T5kvqPCK6Vx6gDORkWO0gz617qVBbIViNsAvn/XgGCWduF4gig7XExnMt8DgicmC/Ye9i2bOsPw4uypaLleNbQ2qKFSfdHJOW/HviUsaE5tsaR9g1pUX03P/E8oDRy11E= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=EKONOpq4jJHGUlnl7jpDWSRsvkroSIwGk5yxnBmlOufEvBddNqmF5JXIh+C9KXtgWu4Y51ck8uxWD1enlLaPXn2MWfj1FGwR/dulwe5c6Dr/DZ3LkmCrxuWRr6LAelZbJvpG96qLYLHW5edOjpUK54Mn/8XukhQwKKkRvgxaCjA= Received: by 10.100.91.17 with SMTP id o17mr22031483anb.94.1198121827925; Wed, 19 Dec 2007 19:37:07 -0800 (PST) Received: by 10.100.41.4 with HTTP; Wed, 19 Dec 2007 19:37:07 -0800 (PST) Message-ID: <7b8774110712191937s402aa94cgd7c1230491fdfe17@mail.gmail.com> Date: Wed, 19 Dec 2007 21:37:07 -0600 From: "Charles Schultz" To: "Jared Still" Subject: Re: Script to build indexes in parallel Cc: Tony_Aponte@jabil.com, Oracle-L In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9421_16739565.1198121827910" References: <7b8774110712181343iea1f042l183452b6bac4049f@mail.gmail.com> X-archive-position: 4031 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: sacrophyte@gmail.com Precedence: normal Reply-to: sacrophyte@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_9421_16739565.1198121827910 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I agree. Tony, thanks, that was close enough to what I was looking for. I have to make some modifications to get_shell, but most of the rest is right on. If anyone is interested, I can post the finished product after we test it (meaning, get rid of my typos). On Dec 19, 2007 5:30 PM, Jared Still wrote: > That's the way it *should* be done. > > 1 queue, multiple servers. > > > On Dec 19, 2007 11:14 AM, Tony Aponte 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@freelists.org [mailto: > oracle-l-bounce@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 > -- Charles Schultz ------=_Part_9421_16739565.1198121827910 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I agree. Tony, thanks, that was close enough to what I was looking for. I have to make some modifications to get_shell, but most of the rest is right on. If anyone is interested, I can post the finished product after we test it (meaning, get rid of my typos).

On Dec 19, 2007 5:30 PM, Jared Still <jkstill@gmail.com> wrote:
That's the way it *should* be done.

1 queue, multiple servers.


On Dec 19, 2007 11:14 AM, Tony Aponte <Tony_Aponte@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@freelists.org [mailto:oracle-l-bounce@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



--
Charles Schultz ------=_Part_9421_16739565.1198121827910-- -- http://www.freelists.org/webpage/oracle-l