RE: PART 2: Ways to move XML data; XMLTYPE w/ CLOB storage
- From: "Marquez, Chris" <CMarquez@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 20 Apr 2005 16:36:30 -0400
For those keeping score;
>>if "INSERT...SELECT" command supports XMLTYPE w/ CLOB storage?
Yes.
>>If SQLPlus COPY command supports XMLTYPE w/ CLOB storage?
No.
Chris
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Marquez, Chris
Sent: Wednesday, April 20, 2005 10:25 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: PART 2: Ways to move XML data; XMLTYPE w/ CLOB storage - RE:
What happened!? IMPort tables with "User Defined or XML Datatypes"....so
slow!
Env:
AIX 5.3
Oracle 9203
=20
Considering that I am hitting a nasty bug for AIX and 9203 regarding
IMPort and XMLTYPE w/ CLOB storage and there is not obvious patch or
fix, I need to find a way to move tables with XML data; XMLTYPE w/ CLOB
storage *AND* some tables with User Defined datatypes.
=20
Would anyone be able to tell me if "SELECT INSERT..." over db links *OR*
SQLPlus COPY command supports XMLTYPE w/ CLOB storage?
=20
PS Anyone have a query to pull a User Defined datatypes definition?
=20
Please reply directly as well as to the list.
=20
Thanks,
=20
Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"
=20
-----Original Message-----
From: Marquez, Chris=20
Sent: Wednesday, April 20, 2005 10:14 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: What happened!? IMPort tables with "User Defined or XML
Datatypes"....so slow!
>>RE: What happened!?
=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!
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 <CMarquez@xxxxxxxx> wrote:=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
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » RE: PART 2: Ways to move XML data; XMLTYPE w/ CLOB storage
