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