From oracle-l-bounce@freelists.org Wed Apr 20 10:18:24 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3KFIOaR010124 for ; Wed, 20 Apr 2005 10:18:24 -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 j3KFIO4Z010118 for ; Wed, 20 Apr 2005 10:18:24 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 546B7185BC0; Wed, 20 Apr 2005 09:16:05 -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 13961-06; Wed, 20 Apr 2005 09:16:05 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CE4D4185D68; Wed, 20 Apr 2005 09:16:04 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain Subject: RE: What happened!? IMPort tables with "User Defined or XML Datatypes"....so slow! Date: Wed, 20 Apr 2005 10:14:15 -0400 Message-ID: <7E412C164E6ECB468834A39F31E6E0D4074B5F99@mbs06dc.na.aarp.int> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: What happened!? IMPort tables with "User Defined or XML Datatypes"....so slow! Thread-Index: AcVCCckAU62EoMzxRMiNLaBlfB15dwDqNU3w From: "Marquez, Chris" To: X-OriginalArrivalTime: 20 Apr 2005 14:14:16.0123 (UTC) FILETIME=[3C30F0B0:01C545B3] Content-Transfer-Encoding: 8bit X-archive-position: 18668 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: CMarquez@aarp.org Precedence: normal Reply-To: CMarquez@aarp.org 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.4 required=5.0 tests=AWL,MANY_EXCLAMATIONS, PLING_QUERY autolearn=no version=2.63 >>RE: What happened!? What happened is that we appear to be hitting a nasty bug for AIX and 9203. A memory leak related to IMPort and XMLTYPE w/ CLOB storage; Metalink Bug 3330477. Casues IMP to slow to a crawl. I was wrong our env is 9203. Chris Marquez Oracle DBA HEYMONitor(tm) - heymonitor.com "Oracle Monitoring & Alerting Solution" ----Original Message----- From: Jared Still [mailto:jkstill@gmail.com] Sent: Friday, April 15, 2005 6:24 PM To: Marquez, Chris Cc: oracle-l@freelists.org Subject: Re: What happened!? IMPort tables with "User Defined or XML Datatypes"....so slow! Try running a 10046 trace on the import session. If the import is being done across the network you may find that imp is very chatty. Jared On 4/15/05, Marquez, Chris wrote: --Env Oracle 9206 AIX 5.x I don't have much experience with "User Defined Datatypes" nor "XML Datatypes".=20 Trying to move a database for a client that uses these datatypes. (not sure but maybe some of them are Nested Tables or VARRAY's vs. "User Defined Datatype"...how can I tell the difference?) Anyway, in the same database I can IMPort * 15GB-20GB normal data (no indexes) per hour. * 10GB GB BLOB data per hour. but only * 324MB of "User Defined Datatypes" After 1 Hr. 15 Min. * 53MB of "XML Datatype" After 30 Min. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l