Skip to Main Content

SQL & PL/SQL

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!

XMLTYPE/CLOB/BLOB which one to choose for better performance?

User495144-OracleJun 18 2015 — edited Jun 18 2015

We have a requirement to store huge xml data as a column in a table. This column will later be accessed via Java code and written to flat files. The xml data could vary from few Kilo Bytes to few Giga Bytes. In this scenario, what is the best suited column type? XMLTYPE/BLOB/CLOB? We have the xml data available in a XMLTYPE variable in the pl/sql code. Tried storing this in a clob column. But there seems to be severe performance issue. The program which was earlier taking 10 minutes to complete is now taking more than 30 minutes. Any pointers? Please let me know.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2015
Added on Jun 18 2015
2 comments
419 views