Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FTP upload speed degrades

590223Nov 28 2007 — edited Dec 13 2007

Hi,

I have an object-relational XMLType table based on a schema. The table and corresponding types are created using registerSchema. This is a relatively simple XSD which translates in the base table plus 1 nested structure.

When I upload an XML document of about 20 Mb the upload slows down very quickly. The first second it is 1.5Mb, the second 0.7Mb, the thid 0.35... etc. until real slow upload of less than 30kb/s. 20Mb takes about 4 minutes to complete (when changing the namespace so that it isn't stored in the OR table but as bin xml the upload is <10 seconds).

I've tried to up the xdbcore-xobmem-bound and xdbcore-loadableunit-size to 50Mb and 25Mb respectively, but that didn't help.

Any hints on what to do or check?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 10 2008

Added on Nov 28 2007

#performance-availability, #xml-db

22 comments

1,542 views