Re: What happened!? IMPort tables with "User Defined or XML Datatypes"....so slow!
- From: Jared Still <jkstill@xxxxxxxxx>
- To: CMarquez@xxxxxxxx
- Date: Fri, 15 Apr 2005 23:23:40 +0100
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:
>
> --Env
> Oracle 9206
> AIX 5.x
>
> I don't have much experience with "User Defined Datatypes" nor "XML
> Datatypes".=20
> 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
> Defined Datatype"...how can I tell the difference?)
>
> 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.
> * 53MB of "XML Datatype" After 30 Min.
>
> --
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
