2 Replies Latest reply: May 10, 2012 1:33 PM by soa_adf RSS

    Composite average payload size in 11g (

      Hi All,

      Thanks in advance.

      I am trying to figure out the average payload size per composite to calculate some statistics.

      I have already looked at the dehydration store table XML_DOCUMENT, however, I cannot seem to figure out how it ties to an actual composite instance in the composite_instance table. I can see it when I am in the EM so it has to be in the database somewhere.

      Querying the XML_DOCUMENT table:

      select document_id , DOCUMENT_TYPE,DBMS_LOB.GETLENGTH(document) a from XML_DOCUMENT

      The composite instance table:

      select * from composite_instance.

      Any help will be very much appreciated.