From oracle-l-bounce@freelists.org Fri Apr 22 10:58:48 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3MFwmvv028340 for ; Fri, 22 Apr 2005 10:58:48 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3MFwR4Z028299 for ; Fri, 22 Apr 2005 10:58:39 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E44FE185F8B; Fri, 22 Apr 2005 09:33:31 -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 16117-09; Fri, 22 Apr 2005 09:33:31 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 67508185012; Fri, 22 Apr 2005 09:33:31 -0500 (EST) Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=LfUfSJqxGToYkbaUKWznDRUYeqdI6YQAcKpllp9Ts7diSBHlSzVDk3iGRMkqaiIQHnWLgJnWrVZbq9lZ1y8odZAHRLyFejqzk7QZLz3/eknvNX4JAM9O3bYHrrI1lKbXwcXJ6+VCOk1KVFx9nF8ZzhmdMBFudrk3DQx/79/exyM= ; Message-ID: <20050422143139.10553.qmail@web52606.mail.yahoo.com> Date: Fri, 22 Apr 2005 07:31:39 -0700 (PDT) From: Martic Zoran Subject: RE: What happened!? IMPort tables with "User Defined or XML Datatypes"....so slow! To: CMarquez@aarp.org, oracle-l@freelists.org In-Reply-To: 6667 MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 18814 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: zoran_martic@yahoo.com Precedence: normal Reply-To: zoran_martic@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.8 required=5.0 tests=AWL,FORGED_YAHOO_RCVD, MANY_EXCLAMATIONS,PLING_QUERY autolearn=no version=2.63 Chris, I agree with you fully. I just wanted to express how ugly performances are with XMLType object types regardless of using CLOB or XML schema as the storage for it. The thing you cannot insert more then few hundreths of records with one XMLType column is what I pointed out. And that is with very hard core tuning :) I know for many memory leak problems with XMLType. I needed to fight them myself with new and new patches. But even without them it is still crap performances. The current usability of XMLType in OLTP environment is very questionable with high level of inserts into XMLType. Regards, Zoran --- "Marquez, Chris" wrote: > > Zoran, > > >>then in 1800 seconds you will > >>insert 90,000 XMLTypes. > > ||"much slower" vs. "not working" > ||>> Metalink Bug 3330477. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- http://www.freelists.org/webpage/oracle-l