From oracle-l-bounce@freelists.org Fri Jun 18 13:39:33 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5IId7w16045 for ; Fri, 18 Jun 2004 13:39:18 -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 i5IIcv615996 for ; Fri, 18 Jun 2004 13:39:07 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6D33972C455; Fri, 18 Jun 2004 13:23:12 -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 31585-23; Fri, 18 Jun 2004 13:23:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C400D72C792; Fri, 18 Jun 2004 13:23:11 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 18 Jun 2004 13:21:51 -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 C7D8572C4C3 for ; Fri, 18 Jun 2004 13:21:50 -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 30915-66 for ; Fri, 18 Jun 2004 13:21:50 -0500 (EST) Received: from owa.metratech.com (mail.metratech.com [199.171.52.172]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 53DB072C58B for ; Fri, 18 Jun 2004 13:21:49 -0500 (EST) Received: from ex2003.metratech.com ([10.10.100.18]) by owa.metratech.com with Microsoft SMTPSVC(5.0.2195.5329); Fri, 18 Jun 2004 14:42:36 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit Subject: Question about Append hint in Insert Date: Fri, 18 Jun 2004 14:42:38 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Question about Append hint in Insert Thread-Index: AcRVYCvgnOvDCr6zS3yk+EjgD6cHiwAA038g From: "Harvinder Singh" To: X-OriginalArrivalTime: 18 Jun 2004 18:42:36.0942 (UTC) FILETIME=[069F72E0:01C45564] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3067 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Harvinder.Singh@MetraTech.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi, We are testing insert performance in one of out tables and we are selecting from 1 table 1000 rows at a time and inserting in 2nd table. So we were getting tps of about 17000 for 1 million records. Then I added append hint to insert and tps went up to 23000. Now if I a try to insert from 2 clients to increase scalibility both insert at tps of 11000. so I have 2 questions: 1) What is the disadvantage of adding append hint during insert (we never delete or update this table in production) 2) Will the hint applicable to all the indexes or only table 3) Why with 2 clients using append result in less tps than normal 2 client inserts? Thanks --Harvinder =20 ---------------------------------------------------------------- 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 -----------------------------------------------------------------