Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 28761 invoked from network); 20 Dec 2007 07:54:52 -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; 20 Dec 2007 07:54:51 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 11F977DD230; Thu, 20 Dec 2007 08:54:52 -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 15432-07; Thu, 20 Dec 2007 08:54:51 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7389C7DCFAD; Thu, 20 Dec 2007 08:54:51 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 20 Dec 2007 08:07:25 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EFFDC7DD2B8 for ; Thu, 20 Dec 2007 08:07:24 -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 03583-05 for ; Thu, 20 Dec 2007 08:07:24 -0500 (EST) Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.232]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9CCD57DD282 for ; Thu, 20 Dec 2007 08:07:24 -0500 (EST) Received: by nz-out-0506.google.com with SMTP id s18so1772979nze.1 for ; Thu, 20 Dec 2007 05:07:24 -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:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=dHp1NIWk/Z7xMMwROd/fJEkliBsWNru9nIFC00DWfRk=; b=DlrZUlioGJsrz1WhvwqO7+OXsJGcNPiFbq+t6OX0iYXVKvpRkGHoS9tELNglZsPku61rNmxvo2qsq70ATzs2/bP5vp+31STcbTEp82G1LaaKrfeXJ3WAJqMyv9OJvEkxdAfvzKE65XTnYJAL2OF9/icTU73Ldojjr2BnQ4djLSE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=qmWqtTSFmqGyEVRkrjLKikmNvHoO4OBuKygLSOXRSEj1MMFNPleT8oBSkhetnICqeI9Pc1rB9UVUEBTj3+VvGfm500Kw42a1fJX4bMZUAd+6x2IYHhMEYPBBKKTd/GfFS92T5n8LZYy2z92cGnj7qaPRZDD/c+U7NTlbxNMK+VE= Received: by 10.142.240.9 with SMTP id n9mr3213593wfh.79.1198156043986; Thu, 20 Dec 2007 05:07:23 -0800 (PST) Received: by 10.142.211.17 with HTTP; Thu, 20 Dec 2007 05:07:23 -0800 (PST) Message-ID: Date: Thu, 20 Dec 2007 07:07:23 -0600 From: "Andrew Kerber" To: sacrophyte@gmail.com Subject: Re: Script to build indexes in parallel Cc: "Jared Still" , Tony_Aponte@jabil.com, Oracle-L In-Reply-To: <7b8774110712191937s402aa94cgd7c1230491fdfe17@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_25511_24655390.1198156043996" References: <7b8774110712181343iea1f042l183452b6bac4049f@mail.gmail.com> <7b8774110712191937s402aa94cgd7c1230491fdfe17@mail.gmail.com> X-archive-position: 4033 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: andrew.kerber@gmail.com Precedence: normal Reply-to: andrew.kerber@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_25511_24655390.1198156043996 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Yes, paresh is a slick program. I have used it myself to parallelize imports. Works great. On Dec 19, 2007 9:37 PM, Charles Schultz wrote: > 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 -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' ------=_Part_25511_24655390.1198156043996 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Yes, paresh is a slick program.  I have used it myself to parallelize imports.  Works great.

On Dec 19, 2007 9:37 PM, Charles Schultz <sacrophyte@gmail.com > wrote:
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



--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.' ------=_Part_25511_24655390.1198156043996-- -- http://www.freelists.org/webpage/oracle-l