Skip to Main Content

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!

ORA-31196 trying to calculate average length of my XML

mbobakJul 18 2010 — edited Jul 24 2010
Hi All,

I'm trying to run the following query:
select /*+ parallel(t 8) */
       avg(dbms_lob.getlength(t.csxml_doc.getclobval())) uncompressed_avg,
       avg(dbms_lob.getlength(t.csxml_doc.xmldata)) compressed_avg,
       count(*) doc_count
  from cs_content_xml_data t;
After this query ran for about 9 hours, I got:
ERROR at line 1:
ORA-12801: error signaled in parallel query server P003, instance
msrac102.dc4.pqe:mstmfgpr2 (2)
ORA-31196: XML nodes over 64K in size cannot be printed
ORA-06512: at "SYS.DBMS_LOB", line 781
The CSXML_DOC column is defined as XMLTYPE with BINARY XML storage.

Can someone help? I'm trying to get the average doc size, both compressed and uncompressed. I think this error is due to the way I'm retrieving the uncompressed data? Not 100% certain of that.

Thanks in advance for any thoughts or suggestions.

-Mark
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 21 2010
Added on Jul 18 2010
15 comments
3,256 views