RE: What happened!? IMPort tables with "User Defined or XML Datatypes"....so slow!
- From: "Marquez, Chris" <CMarquez@xxxxxxxx>
- To: "Martic Zoran" <zoran_martic@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Apr 2005 10:37:28 -0400
"much slower" vs. "not working"
If you seem my original post I was about to do 14GB of normal LOB data =
in just less than 2 hours.
So I don't want to and my testing does not support that this is in any =
way a LOB problem...even though LOBs are slower.
My IMP of XMLType was "not working"...not slow, but crawling =
along...beyond slow.
Also, I opened and read one Metalink Patch Set fix doc (9206?) and found =
tons of bugs related to XML and memory leaks?
Chris
-----Original Message-----
From: Martic Zoran [mailto:zoran_martic@xxxxxxxxx]
Sent: Thu 4/21/2005 8:15 AM
To: Marquez, Chris; oracle-l@xxxxxxxxxxxxx
Cc:=09
Subject: RE: What happened!? IMPort tables with "User Defined or XML =
Datatypes"....so slow!
Does this mean it is now much faster when you remove
that bug?
XMLType insert (with or without LOB storage) is just
measured in 100s, while standard inserts are measured
in 1000s.
So inserting XMLType user types will take to say 10
times longer then normal data inserts :)
XMLType performances are crap even you say, do not
parse, do not validate, just put it into CLOB.
Also the size of XML is not important here as how many
of XML's you are inserting with import.
Anyway, it will be much slower with or without that
memory leak.
--- "Marquez, Chris" <CMarquez@xxxxxxxx> wrote:
> >>RE: What happened!?=20
> =20
> 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.
> =20
> I was wrong our env is 9203.
> =20
> Chris Marquez
> Oracle DBA
> HEYMONitor(tm) - heymonitor.com
> "Oracle Monitoring & Alerting Solution"
> =20
> ----Original Message----- =20
> From: Jared Still [mailto:jkstill@xxxxxxxxx]=20
> Sent: Friday, April 15, 2005 6:24 PM
> To: Marquez, Chris
> Cc: oracle-l@xxxxxxxxxxxxx
> Subject: Re: What happened!? IMPort tables with
> "User Defined or XML
> Datatypes"....so slow!
>=20
> Try running a 10046 trace on the import session.
>=20
> If the import is being done across the network you=20
> may
> find that imp is very chatty.
>=20
> Jared
>=20
>=20
>=20
> On 4/15/05, Marquez, Chris <CMarquez@xxxxxxxx>
> wrote:=20
>=20
> --Env
> Oracle 9206
> AIX 5.x
> =09
> I don't have much experience with "User Defined
> Datatypes" nor
> "XML
> Datatypes".=3D20
> 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=20
> Defined Datatype"...how can I tell the difference?)
> =09
> 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.=20
> * 53MB of "XML Datatype" After 30 Min.
> =09
> =09
>=20
> --=20
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>=20
>=20
>=20
> --
> //www.freelists.org/webpage/oracle-l
>=20
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20
--
//www.freelists.org/webpage/oracle-l
Other related posts:
