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

From: Marquez, Chris <CMarquez_at_aarp.org>
Date: Fri, 22 Apr 2005 11:14:21 -0400
Message-ID: <7E412C164E6ECB468834A39F31E6E0D406689152@mbs06dc.na.aarp.int>

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_at_yahoo.com]=20 Sent: Friday, April 22, 2005 10:32 AM
To: Marquez, Chris; oracle-l_at_freelists.org 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_at_aarp.org> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 22 2005 - 11:53:05 CDT