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: Fri, 22 Apr 2005 11:14:21 -0400

Zoran,

Thanks for the good insight.
I have little or no experience with XML and Oracle.
I'm going to save you email about XMLType in OLTP environment...good to
know.

I try to keep up and have read Oracle Magazine articles on XML in the
past.
Often totally confused by;
 - XMLType /w CLOB (native)
 - XMLType Relational (shredded)
 - XML schema

Thank god for OTN and METALINK to help a DBA weed though the marketing
hype of a new Oracle option.

Hey I thought Oracle was getting simpler with each version...reducing
the need for a DBA altogether.
 ;o)

Thanks,

Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"


-----Original Message-----
From: Martic Zoran [mailto:zoran_martic@xxxxxxxxx]=20
Sent: Friday, April 22, 2005 10:32 AM
To: Marquez, Chris; oracle-l@xxxxxxxxxxxxx
Subject: RE: What happened!? IMPort tables with "User Defined or XML
Datatypes"....so slow!


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" <CMarquez@xxxxxxxx> wrote:
>=20
> Zoran,
>=20
> >>then in 1800 seconds you will
> >>insert 90,000 XMLTypes.
>=20
> ||"much slower" vs. "not working"
> ||>> Metalink Bug 3330477.


__________________________________________________
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: