Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: What happened!? IMPort tables with "User Defined or XML Datatypes"....so slow!

RE: What happened!? IMPort tables with "User Defined or XML Datatypes"....so slow!

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Thu, 21 Apr 2005 08:06:47 -0700 (PDT)
Message-ID: <20050421150647.21957.qmail@web52604.mail.yahoo.com>

You said it is doing:

53MB of "XML Datatype" After 30 Min.

If your database is working at speed of 50 XMLType inserts per second, then in 1800 seconds you will insert 90,000 XMLTypes.

This mean if you have XMLType data that are in average 600 bytes that is exactly these 53M worth of data.

Not sure why are you talking in MB or GB while this is not crazy critical for the speed of import. There are other things there, like number of rows, ...

I am now confused, are you saying import is not working at all?

Regards,
Zoran



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
Received on Thu Apr 21 2005 - 11:11:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US