Retrieve Payload Size From SOA Suite 12c
Hi,
How do we retreive the Size of Payload from SOA_INFRA.
Was using the query below:
ELECT A.DOCUMENT FROM XML_DOCUMENT A,INSTANCE_PAYLOAD B,COMPOSITE_INSTANCE C
WHERE A.DOCUMENT_ID = B.PAYLOAD_KEY
AND B.INSTANCE_ID = C.ID
AND B.INSTANCE_TYPE='COMPOSITE'
AND A.DOCUMENT_TYPE = 2
AND B.INSTANCE_ID = <<InstanceNumber>>;
can see that COMPOSITE_INSTANCE and INSTANCE_PAYLOAD has no records.
Please provide the query for SOA 12c.
Thanks,
Rabin