Database Reference
In-Depth Information
The following screenshot shows the query response that returns four composite
instances associated with this ECID:
Each of those composites has a single component. Thus, we can combine the
output from the CUBE_INSTANCE and MEDIATOR_INSTANCE tables, to also
retrieve a similar flow, but at the component level.
SELECT TO_CHAR(CMPST_ID) COMPOSITE_INSTANCE_ID, COMPONENT_NAME, STATE
COMPONENT_STATE, CREATION_DATE CREATED_TIME, 'BPEL' TYPE
FROM CUBE_INSTANCE
WHERE ECID = 'CB680017C6A0ACFE:-399CCED5:13477C6A1B4:-8000-
0000000000004A0D'
UNION
SELECT TO_CHAR(COMPOSITE_INSTANCE_ID) COMPOSITE_INSTANCE_ID,
COMPONENT_NAME, COMPONENT_STATE, CREATED_TIME D, 'MEDIATOR' TYPE
FROM MEDIATOR_INSTANCE
WHERE ECID = 'CB680017C6A0ACFE:-399CCED5:13477C6A1B4:-8000-0000000000004A0D'
Once again, the query would return the four components and there instance IDs,
as shown in the following screenshot:
Querying the product database tables, though generally discouraged by Oracle,
is perhaps the quickest and simplest mechanism to retrieve detailed instance
information. Chapter 8 , Managing the Matadata Services Repository and De-
Search WWH ::




Custom Search