From oracle-l-bounce@freelists.org Fri Jul 9 20:30:09 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6A1TsX31197 for ; Fri, 9 Jul 2004 20:30:04 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6A1Ti631177 for ; Fri, 9 Jul 2004 20:29:54 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B2F8672C3C0; Fri, 9 Jul 2004 20:10:46 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28917-40; Fri, 9 Jul 2004 20:10:46 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D582D72C39C; Fri, 9 Jul 2004 20:10:44 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 09 Jul 2004 20:09:21 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DB5FD72C0DA for ; Fri, 9 Jul 2004 20:09:20 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28981-05 for ; Fri, 9 Jul 2004 20:09:20 -0500 (EST) Received: from mail.sagelogix.com (unknown [69.15.85.3]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 975CA72C067 for ; Fri, 9 Jul 2004 20:09:20 -0500 (EST) Received: by mail.sagelogix.com (Postfix, from userid 16) id 37201A820E; Fri, 9 Jul 2004 19:29:30 -0600 (MDT) Received: from ocs.sagelogix.com (ocs.sagelogix.com [192.168.25.20]) by mail.sagelogix.com (Postfix) with ESMTP id 65DA4A86BA for ; Fri, 9 Jul 2004 19:29:12 -0600 (MDT) Received: from 0-2pool50-136.nas22.thornton1.co.us.da.qwest.net by ocs.sagelogix.com with ESMTP id 11131291089423154; Fri, 09 Jul 2004 19:32:34 -0600 User-Agent: Microsoft-Entourage/10.1.4.030702.0 Date: Fri, 09 Jul 2004 19:34:32 -0600 Subject: Re: parallel processes and hot blocks From: Tim Gorman To: Message-ID: In-Reply-To: <070920041832.9256.40EEE4A1000C29F7000024282200751150079D9A00000E09D2020E979D@comcast.net> Mime-version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on mail.sagelogix.com X-Spam-Status: No, hits=0.0 required=3.0 tests=none autolearn=no version=2.63 X-Spam-Level: X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4806 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tim@sagelogix.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org No. Direct-path or APPEND insertions executing in parallel do not share blocks. No chance for block-level contention because each process is filling its own "temporary" segment. on 7/9/04 12:32 PM, ryan.gaffuri@comcast.net at ryan.gaffuri@comcast.net wrote: > I have to do a data migration. I am thinking of breaking it into pieces and > running a larger number of array inserts at once into the same table. If I use > 'append', will I run into issues with hotblocks on the insert side if I am > doing 10-20 array inserts into the same table at the same time? ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------